Hello Guys !
I'm trying to show "Roteiro" with the min value of "TempoParado". What i'm doing is :
FirstSortedValue (Distinct (Roteiro), Aggr( sum(TempoParado), Roteiro))
Is returning me anything. It's not every day that I have data on the "Roteiro", then only if I select all "Roteiro" it shows me the script with less "TempoDeParada". If I dont select nothing, nothing returns to me, but I always want the lowest value.
What is happening then is that he sees all values, even when zero, and i need only when have soomething.
How to do it?
Thanks!
