Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi, you can try filtering stores with sales:
=FirstSortedValue({<Store={"=Count(Sales)>0"}>} Store,aggr((sum(Sales)),Store),1)
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
Hi, you can try filtering stores with sales:
=FirstSortedValue({<Store={"=Count(Sales)>0"}>} Store,aggr((sum(Sales)),Store),1)
Thank you so much Marin .
But can you please explain , what was going wrong in my case !
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).