Percentage Calaculation

[haripriya_pampana]

Hi All,

i have created a new calculated measure for percentage for budget and actual. the below is the formula.

if("ZBUDGET"=0,0,(("ZACTUAL"/"ZBUDGET")*100)).

value are correct for few rows but some of them are giving wrong value.

is there any function like in BEx.... NOERR or NODIV.

please help.

[haripriya_pampana · Accepted solution]

This is resolved.

The percentage feild is created before aggregation.

the values are fine now.

Thank you

HP