Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
if((sum({<MO_NM={'MOTOR'}>}[PREMIUM])
/sum({<MO_NM={'MOTOR'}>}[R_BUDGET])*100>=100
AND
(sum({<MO_NM={'NON_MOTOR'}>}[PREMIUM])
/(sum({<MO_NM={'NON_MOTOR'}>}[R_BUDGET]))))*100>=100,
sum([PREMIUM]))
I have above expression which does not work. Pls help me to correct it
I want both Motor and Non Motor to be >= 100% and then sum the Premium
May be few bracket corrections would help, like:
if((sum({<MO_NM={'MOTOR'}>}[PREMIUM])
/sum({<MO_NM={'MOTOR'}>}[R_BUDGET])*100)>=100
AND
(sum({<MO_NM={'NON_MOTOR'}>}[PREMIUM])
/sum({<MO_NM={'NON_MOTOR'}>}[R_BUDGET])*100)>=100,
sum([PREMIUM]))
Note : removed few brackets as well.
Expression shows Ok message . But Results are not shown
Could you post your representative sample qvw?
I attach h/w my document. Pls help
In data you have 'NOM_MOTOR' rather than 'NON_MOTOR'.
Hi Upali
Actual:
if((sum({<MONM={'MOTOR'}>}[PREMIUM])
/sum({<MONM={'MOTOR'}>}[BUDGET])*100)>=100
AND
(sum({<MONM={'NOM_MOTOR'}>}[PREMIUM])
/sum({<MONM={'NOM_MOTOR'}>}[BUDGET])*100)>=100,
sum([PREMIUM]))
Budget:
if((sum({<MONM={'MOTOR'}>}[PREMIUM])
/sum({<MONM={'MOTOR'}>}[BUDGET])*100)>=100
AND
(sum({<MONM={'NOM_MOTOR'}>}[PREMIUM])
/sum({<MONM={'NOM_MOTOR'}>}[BUDGET])*100)>=100,
sum([BUDGET]))
You should also remove MONM as a Dimension as it will make the chart disappear when you expand it.
Maybe change to a straight table instead of Pivot?
Thank for hilighting. Even if it is corrected the resul is not shown.
Please have a look at this
Thanks
I want to to MONM also to appear in the chart