Text box is not displaying worst performing , when there is no selection ?

[shekhar_analyti]

Hi All ,

Text box is not displaying worst performing , when there is no selection ? Also Not getting the date when max sale happened

Not getting the date when max sale happened

Not getting date when max sale happened

[ahaahaaha]

Hi,

If multiple expression values of function FirstSortedValue() have the least sort-order, the function will return NULL. Maybe if you have no selection, you just have a few identical minimum values?

Regards,

Andrey

[rubenmarin · Accepted solution]

Hi, you can try filtering stores with sales:

=FirstSortedValue({<Store={"=Count(Sales)>0"}>} Store,aggr((sum(Sales)),Store),1)

[shekhar_analyti]

Thank you so much Marin .

But can you please explain , what was going wrong in my case !

[rubenmarin]

Not sure but I think that it returned all stores without sales, and FirstSortedValue returns Null() when there are more than one value in the same sorted value (zero in this case).