News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Multiple formulas in s...

Finance | Project Operations, Human Resources, ...

Suggested answer

Multiple formulas in single column

(0) Share

Report

Report

Posted on by MRGGTL

10

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 Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

Bharani Preetham Pe... 3,605 Super User 2024 Season 1 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.
Suggested answer

BassFad 111 on at

Like (0)

Report

Multiple formulas in single column

Column F Normal balance select C next to your revenue accounts
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)

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans