I have a management report set up with Actual compared to Budget. For some of the variances I want to show it as a negative variance and some I want to show as a positive. Is there a way to do a negative variance for specific rows only?
*This post is locked for comments
Hi KenChan
I have query related to AX2012 with Management Report, In AX I have a budget for all revenue accounts I put -VE values for expenses I put +VE values but when I designed the report in Management Reporter all the values in budget column came in -VE value, can you please help me.
Regards
MS
Hi DollyLee,
I am desperately trying to figure out what I'm doing wrong with our company budget statements. Everywhere I read people are suggesting the XCR print control, but our statements are already set up this way and they don't seem to be calculating right. I have double and triple checked that all rows necessary are coded with C for normal credit balance, and my column definition has the XCR, but when I generate this is what I get:
Actual Budget Var F(U)
Sales 112 350 (238)
COS 129.9 269.6 139.7
GP (18) 80.4 (377.7)
Any suggestions?
You should also be able to do it using a custom format of 0;0 or the old FRx way of using an If statement;
(IF D<0 THEN D*-1 ELSE D).
Since a pictures says a thousand words...
Management reporter currently calculates Actual - Budget. However, for "Burn Rate", I need it to calculate Budget - Actual, and for "Sales", I need it to calculate Actual - Budget.
Does anyone have any suggestions on how to change the column formula for specific rows?
Thank you
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (