Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Management Reporter

Management Reporter

(0) Share

Report

Posted on by Community Member

I'm trying to add a column to calculate a figure based on 6.5%. I have 4 columns revenue, cost, and I'm calculating Gross Margin and Gross Margin %. Now I'm trying to include a column that will take the gross margin % column subtract it from 6.5% and multiply it by revenue column. So Basically, column b is revenue, column c is cost, column d is gross margin in dollars, column e is gross margin in %. I need to take column e ( gross margin%) and subtract it from 6.5% and then multiply that difference by column b ( revenue)

*This post is locked for comments

All responses (1)

Answers (0)

EDJJR on at

Like (0)

Report

RE: Management Reporter

Good Morning,

When it comes to formatting complex report, with multiple multiplications, it is best to create a support request. This will then allow us to do either a stream session and bring the report in-house for additional testing.

I do not believe there is a simple fix, which is why a support request would be the best way to go.