Above Function

[soha1902]

Hi All,

Please correct my expression.

I am using Sum(Sales - Above(Sales)), it shaowing error. whats wron in this expression.

Please suggest.

[MK_QSL]

Sum(Sales) - Above(Sum(Sales))

or

Sum(Sales) - Above(Sales)

[its_anandrjs]

Expression is wrong you have to try

Sum(Sales) - Above(Sales)

[soha1902]

I tried but now its showing nothing.

Please find attached sample app.

[MK_QSL · Accepted solution]

What you want to achieve?

You have to select something to get output in text file or use aggr function like below

=Max(Aggr(Sum(Sales) - Above(Sum(Sales)),Sales))

[#6]

Hi Soha,

Try using Sum(Aggr(Sum(Sales) - Above(Sum(Sales)),Sales)) for your requirement.

Regards,

Sabal

[its_anandrjs]

In chart expression you have to use

Sum(Sales) - Above(Sales)

But in text object why you use Sum(Sales) - Above(Sales) it is not good practice what ever you can use this expression will give correct result but sales value not used in aggregation expression some other dimensions are used.

=Max( Aggr( Sum(Sales) - Above(Sum(Sales)),Sales))

[hic]

No, no, no... !!!!

This is a typical case when you don't need the Aggr() function - and probably shouldn't use it. Instead you should just use normal aggregation functions. And note that Above() is not an aggregation function. The correct way to write it is:

     Sum(Sales) - Above(Sum(Sales))

or, if you want to avoid the problem with NULL values:

     RangeSum( Sum(Sales), -Above(Sum(Sales)) )

HIC