Unanswered

Cumulative of column in another column of same table

(0) Share

Report

Posted on by dev77

Hi,

I am new to PowerApps world, I am facing an issue in getting the cumulative values in another column, not able to get the formulae and Rollup is also not working. Need your help. Thanks in advance

Sl. No	Name	Score	Expected result
1	A	10	36.5
2	B	9	36.5
3	C	4	36.5
4	D	6.5	36.5
5	E	7	36.5

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report

@dev77 - based on your table, you're not trying to do a cumulative sum of the Score column, but simply a repeated sum of the whole column. Is that right?

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (0)

Report
Hi @dev77 ,

I assume there is a table:

ClearCollect( NewCollection, {'SI.No':1,Name:"A",Score:10,'Expected result':0}, {'SI.No':2,Name:"B",Score:9,'Expected result':0}, {'SI.No':3,Name:"C",Score:4,'Expected result':0}, {'SI.No':4,Name:"D",Score:6.5,'Expected result':0}, {'SI.No':5,Name:"E",Score:7,'Expected result':0} )

Please try this formula in canvas app:

ForAll( TampTable As TableA, Patch( NewCollection, LookUp(NewCollection,'SI.No'=TableA.'SI.No'), {'Expected result':Sum(Filter(TampTable,'SI.No'<=TableA.'SI.No'),Score)}) ) )

Best Regards,
Bof

Was this reply helpful? Yes No