Not getting default selection as max month after using clear all button

[venky77777]

Hi,

Applied 'Always select one value' option for S_MONTH field, but now when I click on 'clear all' button, I want to display max month in current year. 

Applied actions for 'clear all' button as below image, but not showing current month only showing recent selected month as above (max month to show July)

Can any one suggest, where I'm doing wrong. thanks in advance.

[Or]

Max(Month) is always going to be the selected month, because, well, it's selected.You could try using Max({1} Month).

[steeefan]

Try using MaxString(Month) in case your Month values are strings.

[lennart_mo · Accepted solution]

I think the only problem that may occur with this, is that disregards the selected year, I'm guessing @venky77777 wants the max(month) in the actual year.

So I would suggest using Max({1<S_Year={"$(=Max(S_Year))"}>}S_Month)

[venky77777]

Hi @Or 

Thanks for your reply. I tried Max({1} Month), but it is taking December and showing previous year data. As current year I have data till Sep 2024.

   

[venky77777]

Hi @steeefan ,

thanks for the reply, the same result when I try to use maxstring().

[venky77777]

Hi @lennart_mo  ,

Thanks for reply, it works after adding {1} inside max(S_Year), i.e.

Max({1<S_Year={"$(=Max({1}S_Year))"}>}S_Month).

thanks every one.