Finance | Project Operations, Human Resources, ...

Multiple formulas in single column

(0) Share

Report

Posted on by MRGGTL

Hi. I need to create a report with two different formulas in the same column and am having trouble getting it to work. For example, in the variance column for revenues, I want the formula to be columns C-D. In the same variance column for expenses, I want the formula to be columns D-C. Any suggestions on how to best approach this?

Thanks!

All responses (3)

Answers (0)

Sort by

Mr.QuestiongMark 15 on at

Like (0)

Report
Copy link

Link copied!

sounds you need a if statement to identify which formulas you use in the column. such as if(i=1, C-D, D-C)
Suggested answer

BassFad 163 on at

Like (0)

Report
Copy link

Link copied!

Column F Normal balance select C next to your revenue accounts
Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report
Copy link

Link copied!

The approach is a common approach here. You just need to give a if condition and based on that just populate the value. This can be done in dp class or directly at the report designer level.