Rangesum function error

[hemeshreddy]

Hi guys PFA,

In this for year 2016 i am getting wrong accumulated sum

Regards,

Hemesh

[Anil_Babu_Samineni]

Which graph we need to look? There is 2 graphs

[hemeshreddy]

second graph

[Anil_Babu_Samineni]

What's wrong here?

I used this?

RangeSum(Above(Sum(Sale),0,RowNo(TOTAL)))

And enable Full accumulation radio button

[hemeshreddy]

i need without checking the full accumulation radio button.

[Anil_Babu_Samineni · Accepted solution]

Use this?

RangeSum(above(TOTAL sum(Sale),0,RowNo(TOTAL)))

[hemeshreddy]

it is giving the correct result

May i know what is wrong in that expression which i written

[Anil_Babu_Samineni]

May be TOTAL Keyword missing, And one blog is there for the same. You can read that blog to understand whole

[hemeshreddy]

after giving Total key word also it's giving wrong result,

can u share me the blog URL

[Anil_Babu_Samineni]

Read this?

What does the TOTAL qualifier do?

And, FFor explanation in my way is TOTAL keyword can store the TOTAL sales and then we are displaying to each row level until RowNo(TOTAL) -- How many rows?

And read this too Missing Manual - Above() and Below()