Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys i need some help
I have this info:
How i can filter the max value in the same date, i try this
Max( {< Vol = {">$(=(Max(Vol)))"} >} Fecha)
but the result is negative
Thx for all the help you can give me
Correction
the formula i use is
Max( {< Vol = {"=$(=(Max(Vol)))"} >} Fecha)
Hi
Try this
Max(Aggr(Max(Vol),Fecha))
Hope it helps
Thanks
It works, but i have to change the colum fecha using Max(Fecha)
Thx a lot
Is not working as expected
generate many nulls when i don't select a material
and when in the same day that material have the same Vol show me like null
Hi
try this
Max(Aggr(Max(Vol),Fecha,MaterialName))
Note: In addon uncheck the Zero Value
If it doesn't work can u please send me the QVF I will try and get back to u
Thanks
try below
=if(aggr(if(rank(total max(Volume),0,4)=1,Date),Date) = max(total Date), max(Volume))
Sorry guys as usual the KeyUser change the way to calculate the field 'Fecha', now he wants to see the next min day of Vol staring for the actual day
this is my data
03-01-2020
04-01-2020
06-01-2020
09-01-2020
13-01-2020
14-01-2020
16-01-2020
i use
min( {< Fecha = {">$(=((today())))"} >} Fecha)
and the result is
13-01-2020
14-01-2020
16-01-2020
but i want to show just
13-01-2020
Thanx for all the help and I'm sorry for the inconveniences
Where are you trying this? Can you share sample app to look at?
Here is the data
This is the result i get using the set analysis formula
min( {< Fecha = {">=$(=((today())))"} >} Fecha)
And the date must be 13-01-2020, it depens of the date example iis today is 15-01-2020 the date i want to see is the next min day ( 16-01-2020 )
Thx for all the help