EXPRESSION

sagaraperera — Thu, 25 Aug 2022 04:54:23 GMT

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)))

Re: EXPRESSION

Mark_Little — Thu, 25 Aug 2022 05:56:45 GMT

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.

topic EXPRESSION in Reporting Service & Alerting

EXPRESSION

Re: EXPRESSION