Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Multiple formulas in s...
Finance | Project Operations, Human Resources, ...
Suggested answer

Multiple formulas in single column

(0) ShareShare
ReportReport
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!

  • Suggested answer
    Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,613 Super User 2024 Season 1 on at
    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 Profile Picture
    BassFad 111 on at
    Multiple formulas in single column
    Column F Normal balance select C next to your revenue accounts
  • Mr.QuestiongMark Profile Picture
    Mr.QuestiongMark 15 on at
    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)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

photo of Muhammad Affan

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

thumbnail image of a pie chart section

Top 10 leaders for November!

Congratulations to our November super stars!

thumbnail image of the word Tip

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans