Skip to Content
Former Member
Jan 01, 2013 at 11:26 PM

Need help for Reporting


Dear all,

This my team's first time working with BPC 10, we are trying to make some reports where users need to calculate the unit amount of different concepts (All P&L concepts/Sales Volume). Below the report image that user provided as requirement:

We would like to keep the calculation of unit amount with worksheet logic due we don't need to save the data as result of calculation. But it looks like it's not working as we expect: If we choose another hierarchy of Account dimension, everything is refreshed and text =#REF! is displayed in cells. As we can see in image below:

Do you have any suggestion for setting this calculation succesfully?

Thanks a lot for you help & Regards


Report.png (13.1 kB)
Report 3.png (20.5 kB)