Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the following table:
Date | Production (meters) |
---|---|
01/02/2013 | 108 |
02/02/2013 | 502 |
03/02/2013 | 300 |
04/02/2013 | 0 |
05/02/2013 | 0 |
I want to get the last date which has got a Production value (so it will be 03/02/2013 because the dates thereafter has not values). The date must be able to show in a text box.
How can I do it using a formula/expression?
Thank you in advance
Hi Hennie,
You should solve with this exèression:
Max( {<Production={">0"}>} Date)
Hope it helps
Giampiero
Add a flag in your script (1 when Production >0),
Then your expression will be easy Max({< Flag_production_value = {1} >} Date)
Hi
This should do it
=Date(Max(If(Production <> 0, Date)))
Hope that helps
Jonathan
Hi Hennie,
You should solve with this exèression:
Max( {<Production={">0"}>} Date)
Hope it helps
Giampiero
Hi,
This should work, try this
=Date(Max({<Production={"<>0"}>}Date))
hi
try this
=Date(max({<Production ={"<>0"}>} Date_t))
find the sample application
HTH
Sushil
Hi ,
do the below
1.In script load date as Num(Date) as Date
2.use set ananlysis in text object =sum({<Date={$(=max(Date))}>}value)
Regards,
Anant Dubey
Thank you everyone! I've now got a few expressions from which I can pick and choose!