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
I believe it is working correctly based on the if statement you have applied,
if you look at the chart in the qvw, the 1st part and 2nd part of the expression are never both >=100 in the actual or budgets when looking at it with MNOM as a dimension