Dynamics Community Forum Thread Details

Management Reporter - How to calculate % when I have 2 CBR

Hi All,

I need to calculate percentages for the Income Statement.

1. The 1st base row is row 330. where I put the CBR on row 30. The issue is, it only calculated the percentage on the sales, return...Intercompany sales, but the % calculation did not continue pass base row 330. How do I tell MR to continue calculating the percentage pass row 330?

2. The 2nd base row is row 2100. How do I tell MR to pick up Returns, Restocking Return, and other row to divide it by row 2100? Putting CBR 2100 where I'm highlight below failed to calculate the percentage. Does anyone have any suggestion? Thanks so much!