Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
I want to build an expression where I can see the accumulated sum of one field. I started with an RangeSum function and everthing looks fine but on the second view I saw that when I click on a date the accumulation will start from the beginning. Is there a possibility to create a function which gives back the "total" accumulation when I click on a specific date.
Please look at my example...
Thank you!
PS. My goal is to build a function in the frontend and not in the script enviroment.
I cannot see your qvw (as I am working with Personal Edition), but try something like this:
If(Sum(Sales) > 0, RangeSum(Above(TOTAL Sum({<DateField = >}Sales), 0, RowNo(TOTAL))))
I cannot see your qvw (as I am working with Personal Edition), but try something like this:
If(Sum(Sales) > 0, RangeSum(Above(TOTAL Sum({<DateField = >}Sales), 0, RowNo(TOTAL))))