Rank on Field having empty values.

[retko1985]

Hello,

I am using ONLY aggregation function to display the values (cant use SUM  etc.), now I have a problem, where I need to rank the values, and values having empty string are ranked above the others. But I need them to be below.

Here is an example:

I am also attaching this example file.

Thank you very much.

[olivierrobin]

hello

it's strange

in doc, we see :

Ranking functions in charts

These functions can only be used in chart expressions.

Suppression of zero values is automatically disabled when these functions are used. NULL

values are disregarded.

[sunny_talwar · Accepted solution]

May be use this if you want the rank to be null for when the sales is null?

Rank(Only({<Sales = {"=Len(Trim(Sales)) > 0"}>}Sales),0,1) -> For Blank Sales (not null)

Rank(Only({<Sales = {"*"}>}Sales),0,1) -> For when Sales is truly null

[retko1985]

Great, Thank you