Hi im kinda lost here,
I would like to create a expression that accumulate like the attached table.
Rangesum(above(Diff, ), sum(diff)))
Week | Budget | Sales | Diff | Ack |
2020-01 | 901 143 | 355 096 | -546 047 | -546 047 |
2020-02 | 1 802 286 | 2 835 114 | 1 032 829 | 486 782 |
2020-03 | 2 252 857 | 2 538 308 | 285 451 | 772 233 |
2020-04 | 2 252 857 | 1 347 297 | -905 560 | -133 328 |
2020-05 | 2 252 857 | 1 840 274 | -412 583 | -545 910 |
Hello!
Accumulate expression will be:
RangeSum( Above( Diff ,0 ,RowNo() ))
Hello!
Accumulate expression will be:
RangeSum( Above( Diff ,0 ,RowNo() ))