Skip to main content

Notifications

Community site session details
Power Apps - Microsoft Dataverse
Answered

Probably a Simple FIX -- Rollup column does not display the value

Like (0) ShareShare
ReportReport
Posted on 28 Dec 2022 17:14:47 by 6

Hello Everyone,

Here is my situation:

I have two custom related tables in Dataverse.

Sales Order Table (Parent Table)
- Sale Order Line Items Table (Related to Sales Order Table; Many-To-One)

In the Sales Order Table, I created a column called Total Value of Sale (Data Type: Currency), which is a Rollup to aggregate the SUM of all the Total Sale Per Line (Data Type: Currency) in the Sale Order Line Item Table.

The relationship between the two tables
- One-To-Many from the Sales Order table perspective
- Many-To-One from the Sale Order Line Items table perspective

My issue: The rollup value is not displaying in the Sales Order table.


I tried recreating tables, the relationships, and refreshing data... but no luck.

Any ideas on how I can fix the problem?

  • Verified answer
    EricRegnier Profile Picture
    8,714 Most Valuable Professional on 29 Dec 2022 at 21:03:50
    Re: Probably a Simple FIX -- Rollup column does not display the value

    Yup that's correct, calculated columns that use other calculated columns are considered complex. A common workaround is to use Power Automate to calculate your rollups. 

  • airbornesql Profile Picture
    6 on 29 Dec 2022 at 01:29:56
    Re: Probably a Simple FIX -- Rollup column does not display the value

    Thank you for the response!

    According to the docs, one of the limitations is that  "rollup column formula can't reference complex calculated columns. Only calculated columns that reference simple columns in the same record can be used with rollups."

     

    For my situation, the Total Per Line column in the Sale Order Line Item table would be considered a complex calculated column I think...

    Here is how it is calculated:
    Total Per Line = TotalSellPrice - TotalCost
    - TotalSellPrice = TotalWeightInLbs * SellPricePerPound
    - TotalCost = TotalWeightInLbs * CostPerPound

    -- TotalWeightInLbs = more calculated columns...

    Thank you for pointing me to the docs!

     

  • EricRegnier Profile Picture
    8,714 Most Valuable Professional on 28 Dec 2022 at 21:01:05
    Re: Probably a Simple FIX -- Rollup column does not display the value

    Hi @airbornesql,

    If you just created the rollup field(s) then this is normal. Rollups columns/fields are calculated every 12h. It is a known limitation not to process in real-time not to effect performance of the system.
    More info: https://learn.microsoft.com/power-apps/developer/data-platform/calculated-rollup-attributes?#rollup-columns  
    Note: that are some open source tools to force the roll up field calculation. A popular one is https://github.com/demianrasko/Dynamics-365-Workflow-Tools, see action Force Calculate Rollup.
    Hope this helps!

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
stampcoin Profile Picture

stampcoin 15

#2
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

#3
mmbr1606 Profile Picture

mmbr1606 9 Super User 2025 Season 1

Overall leaderboard

Featured topics

Loading started
Loading started