Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Dear Have you checked the one which I have given?
Is that what you want or not?
Regards,
Kaushik Solanki
Hi,
You can use the Max Function to get the result you need.
Use below function.
Max(Date, -1)
Regards,
Kaushik Solanki
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
Hi Daniyal,
You must have missed the comma.
Regards,
Kaushik Solanki
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.
Here is the application which shows the expression.
Regards,
Kaushik Solanki
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)
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.
Have you given try to the above expression? Is it still not working?
Dear Have you checked the one which I have given?
Is that what you want or not?
Regards,
Kaushik Solanki