Need help for above() function

[ananyaghosh]

Hi,

I have the below data

1	1
2	3
3	6
4	10
5	15
6	21
7	28
8	36
9	45

You can see that for 2nd column, we need to add cumulative sum of values based on first column and I have used the below set expression:-

rangesum(Above(sum([Sales Amt]))) + column(1)

but it does not work for me.

Thanks,

Sandip Ghosh

[Anil_Babu_Samineni]

May be this?

If(sum({$<[Proc Date]={">=$(=YearStart(Max([Proc Date]))) <=$(=Max([Proc Date]))"}>}[Amount]) = 0,Below(rangesum(above(sum({$<[Proc Date]={">=$(=YearStart(Max([Proc Date]))) <=$(=Max([Proc Date]))"}>}[Amount]),0,RowNo())), rangesum(above(sum({$<[Proc Date]={">=$(=YearStart(Max([Proc Date]))) <=$(=Max([Proc Date]))"}>}[Amount]),0,RowNo()))

[ananyaghosh]

Hi,

Your solution does not work for me and it behave like same as before.

Thanks,

Sandip

[Anil_Babu_Samineni]

May be change it to Above rather Below ??

If(sum({$<[Proc Date]={">=$(=YearStart(Max([Proc Date]))) <=$(=Max([Proc Date]))"}>}[Amount]) = 0,Above(rangesum(above(sum({$<[Proc Date]={">=$(=YearStart(Max([Proc Date]))) <=$(=Max([Proc Date]))"}>}[Amount]),0,RowNo())), rangesum(above(sum({$<[Proc Date]={">=$(=YearStart(Max([Proc Date]))) <=$(=Max([Proc Date]))"}>}[Amount]),0,RowNo()))

For me, it's working with out change the script?

Pivot table?

[ananyaghosh]

hi,

I got the below data set at column CUM after I have used your set analysis:

YTD	CUM
217430	217,430.00
24859.97	242,289.97
0	242,289.97
3014.88	3,014.88
0	3,014.88
0	3,014.88
400	3,414.88
2127828.45	2,131,243.33
0	2,131,243.33
0	2,131,243.33
7048.61	2,138,291.94
5150	2,143,441.94
1675367.7	1,675,367.70

  and you can see that for last row and 4th row it is not working. So any suggestion for this?

Thanks,

Sandip