Manager Forum
P&L Statement (Actual vs Budget) Report not showing percentages correctly
AJD
August 5, 2024, 1:20am
1
Sample report:
image
765×542 84.9 KB
Excel sheet showing correct percentages;
image
778×400 20.8 KB
Correct percentages achieved by formula:
=ROUND(IF(C7/D7<0,1-C7/D7,C7/D7),2)
Related topics
Topic
Replies
Views
Activity
Quirk in P&L (Actual vs Budget) report
7
4755
January 18, 2023
Budget Vs Actual Report
6
648
January 18, 2023
Incorrect sum in p/l statement
11
523
January 18, 2023
P&L Statement(Actual vs Budget) Report
4
520
January 18, 2023
P&L Report: Expenses don't tally
12
927
January 18, 2023