Variable

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am using the below expression to get the cumulative in my pivot table .
and there one more expression similar to this.

Is there a way to get this expression written into the script and get a column in the front end ?

rangeSum(Before(TOTAL Count({<Year*={'>2010'},Department={Cosmatics','IT','Finance','Sales'}>}ID)+ Sum(0),0, ColumnNo(TOTAL)))

Can someone please explain me on this

Thanks in advance

Re: Variable

Brett_Bleess — Wed, 04 Dec 2019 17:19:46 GMT

Hey John, yeah, you just need to figure out what table you want that in and then add this to that part of the load scrip:

rangeSum(Before(TOTAL Count({<Year*={'>2010'},Department={Cosmatics','IT','Finance','Sales'}>}ID)+ Sum(0),0, ColumnNo(TOTAL))) as fieldname

If that is not what you meant, please provide some further detail on things, that may precipitate some others chiming in at that point too.

I just realized you may want that in a variable, syntax there would be:

LET variablename = rangeSum(Before(TOTAL Count({<Year*={'>2010'},Department={Cosmatics','IT','Finance','Sales'}>}ID)+ Sum(0),0, ColumnNo(TOTAL)))

Regards,
Brett