ROUND(IIF((.NOT.cmflag.AND.cmpro),(grpval*((cmfirstweight)/100)*(harmony/100))*thrfreqval,0.0000),0) AS ale_pro,;The goal is to get the same numeric format regardless if condition in IIF() is false or true.
>>View 2 >>------- >> >>SELECT IIF((cmflag.AND..NOT.cmpro),ROUND((grpval*((cmfirstweight)/100)*(harmony/100))*thrfreqval,0),0.0000) AS ale_cur,; >> IIF((cmflag.AND.cmpro),ROUND((grpval*((cmfirstweight)/100)*(harmony/100))*thrfreqval,0),0.0000) AS ale_imp,; >> IIF((.NOT.cmflag.AND.cmpro),ROUND((grpval*((cmfirstweight)/100)*(harmony/100))*thrfreqval,0),0.0000) AS ale_pro,; >> IIF((.NOT.cmflag.AND..NOT.cmpro),ROUND((grpval*((cmfirstweight)/100)*(harmony/100))*thrfreqval,0),0.0000) AS ale_non,; >> ROUND(cmfirstweight/100,2)*ale_max AS cmfinalweight, Q_risk_ale3.*; >> FROM ; >> VIew1; >> ORDER BY VIew1.vulname, VIew1.grpname,; >> VIew1.thrname, VIew1.cmref >