Hi
In this dynamic report (ad hoc report) there is a constant dimension - StoreID, and the other 2 dynamically change according to the user's selections in the upper filters (same with the measure)
each column is showed conditionally: =SubStringCount(Concat([Float2.Num],'|'),01)
This is my measure:
if( $(vFloatMeasure)>= Max( total <StoreID> Aggr( $(vFloatMeasure),StoreID, $(vDimFloat2),$(vDynFloat1)) )-1,
Max( total <StoreID> Aggr( $(vFloatMeasure),StoreID, $(vDimFloat2),$(vDynFloat1)) ),
Null()
)
I'm showing the highest value per store, meaning one row only per store.
For some reason, although unchecked the "include nulls" checkbox, I still have rows with null values.
any idea how do I get rid of it?
Thanks