Answered

Aggregate / roll up like functionality in formula columns

(0) Share

Report

Posted on by Rutu01

305

Is it possible to aggregate values of rows in a formula column? I have a table that has a self referencing column. And I want to add the quantities of all rows where rowid = current row or self referencing column refers current row.

If this is not possible in a formula column, then can rollup column be used for this? I am unable to sum the rows of same table in a rollup column

Categories:

Microsoft Dataverse

All responses (3)

Answers (1)

Rutu01 305 on at

Like (1)

Report

Re: Aggregate / roll up like functionality in formula columns

Could save it, not sure what the problem was earlier
Rutu01 305 on at

Like (0)

Report

Re: Aggregate / roll up like functionality in formula columns

Hi @Jmanriquerios Thank you for your help. Could you please tell me how to save the grouped view? I added the power grid control and added the group and aggregate but am unable to save it
Verified answer

Jonathan Manrique 2,678 on at

Like (1)

Report

Re: Aggregate / roll up like functionality in formula columns

Hi @Rutu01

There is a new feature in preview that will help you resolve this situation.
Check out this article I wrote to see if it helps you.

https://www.linkedin.com/pulse/power-apps-grid-vitaminado-jonathan-manrique-w78yf/?trackingId=Dw0cS3PTSHCBuWrArOfPlA%3D%3D