topic Re: cumulative sum for different values in App Development

cumulative sum for different values

c_pannese — Sat, 16 Nov 2024 02:52:46 GMT

How can i obtain the cumulative sum for each product like the column ?

thanks

ashishkalia — Thu, 26 Mar 2020 02:14:29 GMT

You have to do it in the back-end.

Create a new field with using this formula:

If(prod = Previous(prod), (gg + Previous(gg)), gg) as CumulativeSum

*don't forget to put order by clause in where condition (Order By date, prod)

attached link for the similar issue: Similar Post

Let me know if works.

Regards,
AK

c_pannese — Thu, 26 Mar 2020 05:17:58 GMT

I can't because gg is a measure. In the script i don' t have this field,it is a variabile value.