
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Above function generates null in some rows
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
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Actually you need to thank to the person who has wrote Missing Manual...

.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Try
=Above(TOTAL Sum(Sales))
Hope it helps you.
Regards,
Jagan.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks a Lot for the links especially the missing manual helped a lot to get things clear

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Jagan .

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Actually you need to thank to the person who has wrote Missing Manual...

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I did it as soon as I read . he has taken lot of effort in writing that
