Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Management Reporter - ...

Management Reporter - Varying Column Calculations

(0) Share

Report

Posted on by KenChan

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

*This post is locked for comments

All responses (2)

Answers (0)

KenChan on at

Like (0)

Report

RE: Management Reporter - Varying Column Calculations

Is there a ways to do it without having he modify the report every month? lets say by setting the row?
Phil Rimmer 450 on at

Like (0)

Report

RE: Management Reporter - Varying Column Calculations

Your best bet would be to use and IF THEN ELSE statement. You will have to find something that is unique to your burn rate column though so it may need tweaking each month.