web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Calculated field (powe...
Power Apps
Answered

Calculated field (power FX) - sum of related records?

(0) ShareShare
ReportReport
Posted on by Medoomi 523

I guess I'm really asking about using the Power FX formulas in a calculated field (in preview).

 

I have two Dataverse tables. One is called "payments" and within this table, it has a column called "amount," recording payments, of a currency type, and a second lookup column which designates a "project" from the second Dataverse table. This second table, "projects," is related to payments as a 1*N.

 

Is it possible within the "projects" Table to create a calculated column "total paid," which would sum all the related "amount" records from the "payments" table?

Categories:
Microsoft Dataverse with Power Apps
I have the same question (0)
  • Fubar Profile Picture
    Fubar 8,514 Super User 2026 Season 1 on at

    Yes.

     

    There used to be a trick for getting currency fields rollups to work, but can't remember exactly what it was, it was something like making sure the out of the box "currency" field the one that indicates its USD, Euro etc (not the field you created) was on the parent records form (but it could be set not visible).

  • Verified answer
    Medoomi Profile Picture
    Medoomi 523 on at

    Thanks so much @Fubar , I did a bit of digging & the "rollup" option is found on the "behavior" field when creating a new column in Dataverse (if the Data type is set to currency, date & time, or number).

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 342 Most Valuable Professional

#2
11manish Profile Picture

11manish 234

#3
Valantis Profile Picture

Valantis 187

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans