Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Management Report - Calculation increase in TOTAL Revenue Quarter over Quarter

Posted on by

Hello - I am trying to compare Q1'21 to Q2'21 in my report by showing a % increase in Total Revenue.  I seem to be able to get the 5 working for all the static lines, but it is blank for the total line. Do you know what I may be doing wrong?

I used the formula in the column definition:

pastedimage1633723689732v1.png

Thank you!

Steph

Categories:
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Management Report - Calculation increase in TOTAL Revenue Quarter over Quarter

    Hello Steph,

    Can you take a look at this post and compare the way how you calculated your total with what is described in this article?

    redbeardblogging.blogspot.com/.../how-to-do-cross-column-formulas-in.html

    Best regards,

    Ludwig

  • Sdales Profile Picture
    Sdales on at
    RE: Management Report - Calculation increase in TOTAL Revenue Quarter over Quarter

    Hello - 

    It didn't seem to help. Now  the Revenue total line is using the "row definition" formula to add up the lines above it, not perform the "column definition" formula to do a % increase/decrease from the previous quarter:

    pastedimage1634051760523v2.png

    Any ideas, thanks again for your help!

    Steph

     

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Management Report - Calculation increase in TOTAL Revenue Quarter over Quarter

    Hello Steph,

    Have you tried flipping the calculation priority as Osman suggested?

    Did this fix your issue?

    Best regards,

    Ludwig

  • Suggested answer
    OsmanIstanbul Profile Picture
    OsmanIstanbul 2,801 on at
    RE: Management Report - Calculation increase in TOTAL Revenue Quarter over Quarter

    Hi,

    try to change calculation priority on report definition.

    Best regards.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans