Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends
My following expression does not return a value
=SUM(IF(Aggr(SUM({<RISK_DATE={$(vP16)}>}FIN_PREMIUM)/SUM({<RISK_DATE={$(vP16)}>}FIN_PREMIUM),CRE_NAME_1)>.1,SUM({<RISK_DATE={$(vP16)}>}FIN_PREMIUM)))
Pls advise where I have made the error
What do you want to achieve?
Maybe
=IF(
Sum(Aggr(SUM({<RISK_DATE={$(vP16)}>}FIN_PREMIUM)/SUM({<RISK_DATE={$(vP16)}>}FIN_PREMIUM),CRE_NAME_1)) >.1
,SUM({<RISK_DATE={$(vP16)}>}FIN_PREMIUM)
)
Otherwise there are two issues: the condition is only true if your comparison returns same result for all CRE_NAME_1 and the THEN branch is an aggregation embedded into another.
Hi
I want to show in my Pivot table only A,B,F where % is >.1. My Calculation is Individual Fin_premium/ Total FIN_Premium
also try this
=sum(aggr(IF(SUM({<RISK_DATE={$(vP16)}>}FIN_PREMIUM)/SUM({<RISK_DATE={$(vP16)}>}FIN_PREMIUM)>.1,SUM({<RISK_DATE={$(vP16)}>}FIN_PREMIUM)),CRE_NAME_1))
or
=SUM(aggr(IF(Aggr(SUM({<RISK_DATE={$(vP16)}>}FIN_PREMIUM)/SUM({<RISK_DATE={$(vP16)}>}FIN_PREMIUM),CRE_NAME_1)>.1,SUM({<RISK_DATE={$(vP16)}>}FIN_PREMIUM)),CRE_NAME_1))
Both of Your expression works but none meet me condition of .1
Won't you Need a TOTAL qualifier in the denominator of your division? Looks like the division is constant 1.
Kindly modify the expression and show
Maybe
=Sum(
Aggr(
IF(
SUM({<RISK_DATE={$(vP16)}>}FIN_PREMIUM) / SUM(TOTAL {<RISK_DATE={$(vP16)}>}FIN_PREMIUM)>.1
,SUM({<RISK_DATE={$(vP16)}>}FIN_PREMIUM)
)
,CRE_NAME_1)
)
It's not working because you have another expression %, in that expression also you need to write the if condition
aggr(IF(SUM({<RISK_DATE={$(vP16)}>}FIN_PREMIUM)/SUM({<RISK_DATE={$(vP16)}>}FIN_PREMIUM)>.1,
SUM({<RISK_DATE={$(vP16)}>}FIN_PREMIUM)/SUM({<RISK_DATE={$(vP16)}>}FIN_PREMIUM)),CRE_NAME_1)