Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sagaraperera
Creator
Creator

EXPRESSION

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

Labels (1)
1 Reply
Mark_Little
Luminary
Luminary

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.