Get last date for which has a value

[Anonymous]

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

[vivientexier]

Add a flag in your script (1 when Production >0),

Then your expression will be easy Max({< Flag_production_value = {1} >} Date)

[jonathandienst]

Hi

This should do it

=Date(Max(If(Production <> 0, Date)))

Hope that helps

Jonathan

[#4 · Accepted solution]

Hi Hennie,

You should solve with this exèression:

Max( {<Production={">0"}>} Date)

Hope it helps

Giampiero

[manideep78]

Hi,

This should work, try this

=Date(Max({<Production={"<>0"}>}Date))

[sushil353]

hi

try this

=Date(max({<Production ={"<>0"}>} Date_t))

find the sample application

HTH

Sushil

[Anonymous]

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

[Anonymous]

Thank you everyone! I've now got a few expressions from which I can pick and choose!