above function?

[#1]

above(sum(Sales), 2)+above(sum(Sales), 1)       how to calculate  this   above(sum(Sales), 2)

PLS  HELP  ME 

sales:

800

1200

1000

  30

[MK_QSL]

What is your requirements?

[hic]

You should not use '+' together with the inter-record functions since these return NULL sometimes, and '+' doesn't work with NULL.

Instead, you should use RangeSum():

   RangeSum(above(sum(Sales), 2), above(sum(Sales), 1))

But just as Manish Kachhia, I wonder what you really are trying to do...

HIC

[#4]

Hi henric

how it is calculating here for this expression above(sum(Sales), 2

above(sum(Sales), 2=?  what is output and  how  pls tell me

i am thankful to u

[jagan]

Hi Manoj,

Suppose you have a straight table like below then

S.No.      Sum(Sales)      Above(Sum(Sales), 2)

1               5                         -

2               10                        -

3               20                        5

4               25                       10 

5               30                       20

Here Above() will give the Previous row expression values, if you do not give second parameter (2) then it returns the above row value, if you specify 2 then it will return second above row.

Hope this helps you.

Regards,

Jagan.

[jagan]

Hi,

Continuation to my previous post

For the first two rows you don't have second previous rows that is why you are getting Null values.

Regards,

Jagan.

[#7]

Thank u very much yar

like wise if u take below then it will give current line below rows right

[jagan]

Yes.

Regards,

jagan.

[SunilChauhan]

above(above(sum(Sales)))+above(sum(Sales))