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!

I have the same question (0)

All responses (3)

Answers (0)

Mr.QuestiongMark 15 on at

Like (0)

Report

RE: Multiple formulas in single column

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

Was this reply helpful? Yes No
Suggested answer

BassFad 153 on at

Like (0)

Report

Multiple formulas in single column

Column F Normal balance select C next to your revenue accounts

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

Multiple formulas in single column

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.

Was this reply helpful? Yes No