Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.
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
Great, Thank you