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

I have the same question (0)

All responses (1)

Answers (0)

EDJJR on at

Like (0)

Report

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.

Was this reply helpful? Yes No