Urgent Help In Calculated Column

[KANUL]

Hi ,

I am facing a problem in calculation . I have a query Subject with columns :-Year , Month , Division , Actual , Budget & calculating Actual/Budget  as Opex % in FM . I have made Qpex % as Calculated.

When I create a list in reports studio & Drag Year , Month & Opex % , It is giving me wrong results. It is aggregating the Opex value which is wrong. It should calculate the Opex % with the dimensions present in the list.

So the opex % for 1st row should be 1010000/1151000 =.88

Year    Month  Actual          Budget       Opex %
2010    1        1,010,000    1,151,000   2.52813853
2010    2        393,000       418,000      2.70631229
2010    3        78,456         89,459        2.47813299

[PRIT AMRIT]

Instead of 'Opex' item from FM, create a Data Item with the below expression and use the same in your List Report

Total(Actual)/Total(Budget) and make the aggregated properties as 'Calculated'.

Hope should work for you

Thanks

[leahmarie]

You can also change the properties to be before or after aggregation and you might look into changing the solve order.