Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
if i don´t select a month or year i want my expression to be labeled as previous month and current year (May 2012). if i select now may, it should be labeled as April 2012. I tried the following expression, but the else statement isn´t working:
='Umsatz ' & | if(GetSelectedCount(Month)=0, Monthname(Today()-31), only(Month)-1 and only(Year)-1) |
Any ideas?
Hi,
Try this,
='Umsatz ' & MonthName(MonthStart(Max(Date),-1))
Where Date is the field from where you generate the year and month field.
Hope it helps,
R.Mayil Vahanan
Another way:
='Umsatz ' & MonthName(AddMonths(Today(),-1))
Hi
Monthname(addmonth(today(),-1)) will work.
Thank you
Meher
Sorry no of those answers work correctly.
with today(), it´s not flexible anymore. again, it´s about the lable not the calculation expression. and if i select nothing, the result must currently be: May 2012. if i select e.g. may 2012, it must be april 2012.
if i select november 2011 it must show october 2011. always one month backwards. thanks for helping!
= if(GetSelectedCount(Year)=1 or if(GetSelectedCount(Month)=1,'Umsatz ' & MonthName(AddMonths(Today(),-1)),
'Umsatz ' & MonthName(Today()))