Yes, you're correct that IIF() causes the problem because it returns different numeric format in each case. You can try

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.

>I noticed that I start getting teh error after I added the IIF() in the second views.
>
>OK, the select part only, View 1
<snip>>

>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