Forum Discussion
Add cell value of multiple rows in same column
Hello, Can someone throw some light on the implementation of the below scenario. UID Value Expected Result Formula for Math 1 100 100 =Value(1) 2 20 20 =Value(2) 3 12...
jaideepnema
Solution Sage
Solution SageHi Anonymous ,
Create a calculated column like this
Expected Value = IF(ISBLANK(Data[Value]),CALCULATE(SUM(Data[Value]),Data[ID]<=EARLIER(Data[ID]),ALL(Data)),Data[Value])
Where data is the table name of your dataset being used
Please accept this as a solution if your question has been answered !!
Appreciate a Kudos 😀
Thanks for your efforts.
I might have missed this. But, the summation is not always with EARLIER cell value or <= case.
It could beRow 3= Row1+Row2,
Row 9 = Row 2+Row7,
Row 10 = Row7+ Row9