Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
Hope all re doing good....!
I need help on selecting the month which has recent data as a default selection while opening the application.
For Ex: i have year filed 2015 and in 2015 i have data till may only.
so when i opened my application by default it has to show may.
my month filed has month names not numbers.
i tried Max(month) in document triggers but its not working.
Please help on this.....
Thanks in advance...
Nani.
Please see the attached file once more.
hi
PFA
when ever you want to disply recent selected
you must chk dat option and save it and close
and reopen ur application....you will get last selected values
hope this helps you
Thank you
Suresh
Hi,
Can you attach sample file, it would be easier to provide the solution.
Or try this
=Text(Date(Max(Month), 'MMM'))
Regards,
Jagan.
Hi Suresh,
That is the case in my requirement.
I have to default month to max month which has the data in our application(not last selected month) in month filter.
in 2015 we have data upto may.
so in my scenario I have to default it to may.
Try
MaxString(Month)
On Field Value Trigger try char(max(month))
Hi Ashish,
Thanks for your solution.
It is working fine...
Regards,
Nani
hi
try as
sum({<Row={"=[MaxDate] >= max(total [Months]) <="})
Thank you
Suresh
Hi,
This is not the correct solution
If you have data upto december this will return September not December. Verify it. If you attach sample file it would be easier to understand your data.
MaxString(Month)
Regards,
Jagan.
Hi Jagan,
I tested with 2014 data where I have data till December and it is working and returned Dec.
Thanks,
Nani