Finance | Project Operations, Human Resources, ...

Variance column with normal formula and percentage calculation

(0) Share

Report

Posted on by Amanda_C

Hi guys,

I have a financial summary report with the following criteria per contract:

6685.Example.png

The variance column is (Actual less Budget), but the contribution margin % row should be (Contribution margin divided by Revenue) to still get an accurate %

How do I configure this in MR?

Thanks in advance!

Amanda

Categories:

Microsoft Dynamics GP

All responses (3)

Answers (0)

Amanda_C 5 on at

Like (0)

Report

RE: Variance column with normal formula and percentage calculation

Thanks so much for the help previously, changing the settings to "Perform column calculations first then row" helped.

BUT now I have another issue.

Within the same report I want to now add a % variance against the Variance column.

My calculation in the column definition is IF C>0 THEN E/C ELSE 1.0 [C being FY20-Q3F forecast and E being the variance column]

I get the correct answer against the Contribution Margin % line, but the other percentages just doesn't show, no matter what I try.

Your help is again highly appreciated!

Amanda
Suggested answer

Amanda_C 5 on at

Like (0)

Report

RE: Variance column with normal formula and percentage calculation

Excellent! That easy... I appreciate your help Greg!

Amanda
Greg Byer 2,586 on at

Like (0)

Report

RE: Variance column with normal formula and percentage calculation

Hi Amanda,

In the report definition, click on the Settings tab. Then change the Calculation Priority to 'Perform column calculations first and then row'. That should give you the correct amount for the Contribution Margin % row. I tested it and got the correct amount.