Forum Discussion
NadeemAhamed
Helper V
Helper VRow wise calculation in percentage
Dear Community. Good Day. I have posted this before, unfortunately i didn't get the answers. Requesting all to help me out. I have one P&L report. in this i have received only Plan and Ac...
NadeemAhamedHelper V
Helper V
For Plan and Actual column data is correct- Gross Profit Rate = Gross Profit/Sales.
Variance and Acheivement column for "Gross Profit Rate" values should be like other values in the column .
Variance = 440.0% - 25.00%=415%
Achievement = 440.0% / 25.00% = 17.6%
NadeemAhamedHelper V
Helper V
what pbix file you have shared that is contain the old pbix data.
Is it that you have shared?