Max day issue

[#1]

Dear All

my source is  sankar_20.12.11.qvd

No	name	amt	date
1	sankar	100	16.12.11
2	sankar	200	18.12.11
3	sankar	0	19.12.11
4	sankar	0	20.12.11

Here i am storing data day wise cumulative like below

sankar_16.12.11.qvd

sankar_18.12.11.qvd

sankar_19.12.11.qvd

sankar_20.12.11.qvd

In final application front end max(day)  i am taking that time it is showing ZERO.it is right but my requirement is if max day or yesterday data  and ....

is zero then it should display the 18th day data(if 18th data zero then display 16th day like)

Help me please

Regards

sankar

[vijay_iitkgp · Accepted solution]

Hi,

You can use  Max(If(amt>0,date) 

Regards

VIjay