Reporting Service

[sagaraperera]

DEAR ALL

ERROR IN EXPRESSION MASSAGE will appear in the FORMULA mentioned below. How to fix it please..

Sum({$ <DESCRIPTION={"NET_PROFIT"}>}

(Sum({$ <DESCRIPTION={"GROSS_PREMIUM"}>} Total ACTUAL)*Sum({$ <TYPE={"discount"},DESCRIPTION={"GROSS_PROFIT"}>}BUDGET)/Sum({$ <DESCRIPTION={"GROSS_PREMIUM"}>} Total BUDGET)
-Sum({$ <TYPE={"not_discount"},DESCRIPTION={"MANAGEMENT_EXPENSES"}>}ACTUAL)+Sum({$ <DESCRIPTION={"GROSS_PREMIUM"}>} Total ACTUAL)*Sum({$ <TYPE={"discount"},DESCRIPTION={"INV_OTHER_INCOME"}>}BUDGET)/Sum({$ <DESCRIPTION={"GROSS_PREMIUM"}>}Total BUDGET)))

[mark6505]

Hi @sagaraperera 

It might help if you explain your requirement for the Set Analysis. The Error you are getting is for nested aggregation. This is because you have wrapped SUM( {$ <DESCRIPTION={"NET_PROFIT"}>}) around other SUM functions with no AGGR() function.

Also i would be careful with BODMAS with the inner expression.