You’re offline. This is a read only version of the page.
4
I am working on a Power Pages project where I have a " table1" and a " table2". The table1 contains a "ID" field, and the "table2 " has a corresponding "ID" field to establish the relationship.
I need to calculate the total amount for a specific "ID" based on the "Amount" field in the " table2". How can I achieve this in Power Pages? Can you provide a formula or guidance on setting up the calculation?
I appreciate any assistance or insights you can provide.
Thank you!
One of the ways you can do that is by using Rollup Columns which is a special type of calculated column that automatically aggregates data from related records in another table. It allows you to display summarized information, such as counts, sums, averages, or other calculations, without requiring complex formulas or custom code.
You can then display the result in your page.
Hello @aishwarya31
In my recent project, I needed to replicate a similar behavior. In my scenario, I only had 'table 2' containing 'id' and numbers to calculate the sum. To achieve this, I wrote several functions in a JavaScript file corresponding to the respective page.
My approach involved the following logic:
Each row in the table(shown in the page) corresponds to an 'id' that matches with the 'id' from Dataverse, making it straightforward to populate the table with data from {id1: sum, id2: sum, id3: sum}".
As a result, I filled in the last field with the sum (just example):
#1
Fubar
69
Super User 2025 Season 1
#2
oliver.rodrigues
49
Most Valuable Professional
#3
Jon Unzueta
43
Share
Report
All responses (
Answers (
