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
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
You can also change the properties to be before or after aggregation and you might look into changing the solve order.