Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
i am trying to use the peek()-function to create the cumul. value, but i get wrong results, i am using this expression:
RangeSum(value,Peek(CumulativeSum)) as CumulativeSum. but i still have the wrong results, my expected output is Column: CumulValue
My Table does look like:
Year | Month | Day | Material | Index_ID | quantity | price | Value | CumulValue |
2021 | Jan | 1 | A1 | 12 | 2 | 100 | 200 | 200 |
2021 | Feb | 2 | A1 | 15 | 2 | 55 | 110 | 310 |
2021 | Mar | 3 | A1 | 13 | 3 | 12 | 36 | 346 |
2022 | Jan | 1 | A1 | 12 | 4 | 10 | 40 | 386 |
2022 | Feb | 2 | A1 | 45 | 4 | 10 | 40 | 426 |
2022 | Mar | 3 | A1 | 12 | 2 | 10 | 20 | 446 |
Does anybody have any idea how to resolve this issue?
Thanks a lot
Chart Expression
rangesum( above( sum(Value),0,rowno()) )
Script field
RangeSum(value,Peek('CumulativeSum')) as CumulativeSum // missing single quotes, fields need to be passed as string
What are those wrong results?
Chart Expression
rangesum( above( sum(Value),0,rowno()) )
Script field
RangeSum(value,Peek('CumulativeSum')) as CumulativeSum // missing single quotes, fields need to be passed as string
Hi Marco, i had normal numbers, not cumulated. Now I have solved it,
I just forgot the single quotes. Thanks for your time and help
Hi Vineeth, thank you very much for time and help