MR formula to compare 1 column to the CBR in another column

(0) Share

Report

Posted on by Patrick Jarvis

300

How do I create a formula that allows me to look at another columns CBR. I am trying to calculate a % of Revenue against a column that only has Overhead cost (no revenue).

I have a consolidated column that is not printed that I want to refer to.

Thought the formula would be (Column CU divided by the baserow for column CV) How to do this?

CU/Baserow(CV) (where Baserow(CV) is the base row of column CV not CU.

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Ryan Sandness on at

Like (0)

Report

Patrick,

I think you can use a simple CALC in the column for this request. I setup a very simple report to test this.

The column looks like:

DESC, FD Actual Periodic, CALC B/BASEROW, CALC C/B.175

The last calc column will divide everything in column D (or in your case CV) by row 175 of Column B.

Thanks

Ryan

Was this reply helpful? Yes No