Above function generates null in some rows

[fashid]

Hi,

I was trying to learn the above function and i created some sample data to play with it.

I am facing a problem with my expression  "=Above(Sum(sales))"  which should simply return the sum of sales from the previous row.

My query is that I do not get values for the month of Jan 2013 and jan 2014.

Could you please tell what the issue could be .

I am attaching the sample app that am working on.

Thanks

Nadeem

[jagan]

Hi,

Try

=Above(TOTAL Sum(Sales))

Hope it helps you.

Regards,

Jagan.

[MK_QSL]

Missing Manual - Above() and Below()

The Above Function

[fashid]

Thanks a Lot for the links especially the missing manual helped a lot to get things clear

[fashid]

Thanks Jagan .

[MK_QSL · Accepted solution]

Actually you need to thank to the person who has wrote Missing Manual...

[fashid]

I did it as soon as I read . he has taken lot of effort in writing that