data extraction problem

[#1]

Date Field	AUM
1	10
4	20
5	21
6	22
7	23
9	24
10	25
11	26
15	27

i have data like this what i want max date in one field of pivot and previous in other.

Catch here is that when i select 15 as maximum in previous column i want "11" date also its value specifically.

i did make variable of max through which i can extract 15 but to extract 11 is bit problem for me also not able to extract its  SUM of that day AUM.

[kaushiknsolanki]

Hi,

You can use the Max Function to get the result you need.

Use below function.

Max(Date, -1)

Regards,

Kaushik Solanki

[#3]

i did use the same but i select Max(date,-1) it gives me 14 date instead of 11 i need 11 and its data

[kaushiknsolanki]

Hi Daniyal,

You must have missed the comma.

Regards,

Kaushik Solanki

[#5]

sir,

these are actual dates but i converted them into numbers,i could not find a solution if you could please share Qvd which is workable and also share other formula if it is not working.

[kaushiknsolanki]

Here is the application which shows the expression.

Regards,

Kaushik Solanki

[sunny_talwar]

Do you happen to have master calendar in your application where you have created all the dates, but you are looking for date which have  last AUM? You can give this a try:

Max({<AUM = {"=Len(Trim(AUM)) > 0"}>} Date, -1)

[#8]

i have date field not a master calendar and i put these dates in List box and convert them in days number number by using =day(Dates) but my dates are not constant from 1-31 my dates have missing dates of Saturday and Sunday as i given above.

i do not want missing dates of Saturday and Sundays.

[sunny_talwar]

Have you given try to the above expression? Is it still not working?

[kaushiknsolanki · Accepted solution]

Dear Have you checked the one which I have given?

Is that what you want or not?

Regards,

Kaushik Solanki