Hi Hayasaka,

we have new attribute option in aggregate .In the new attribute you can calculate  Sales attribute + Total price:

For example

Hope this Helps.

Regards

Samiksha

Hi Hayasaka,

What you can do is to create a server action with input SalesAmount and Total as the output parameter and also one session variable as SalesAmountTotal with default value 0 and mark the server action as function.

In that server action, add an assignment as Total = SalesAmount + SalesAmountTotal. and SalesAmountTotal = Total

Use this inline function inside your Total column in screen. 

NOTE: Don't forget to assign SalesAmountTotal session variable to 0 in preparation as the value persists till session is valid

I'm getting the desired result as below:

Hope this helps! Thanks :)

Hi Hayasaka,

It would be better to give a try with Advance SQL query to add the previous value with the current value. Please see sample query.

Select *, Sum(SalesAmount) Over ( Order by Date ) As CumSum_ByDate
From {yourEnitityName}

Thanks & Regards,

Sachin