Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I am trying to use an expression in a Lable.
Is there any way to use if statement in the lable.
I am trying to read the selected monthname, if the monthname is dec then execute a set of statements else do another.
MonthName is a field from Jan to Dec.
Syntax:
=IF({$<[MonthName]={'Dec'}>},1,2)
How does this work ?
Thanks,
Srihari
Hi Srihari,
Use
=If(Match(MonthName, 'Nov', 'Dec') > 0, 1, 2)
That should work.
Use the below code
if(MonthName ='Dec' ,1,2)
HI Deepak,
that is working fine.
Can this work ?
I want to get 1 when the month is in nov or dec.
Syntax :
If (MonthName='Dec','Nov',1,2)
or
If (MonthName in ('Dec','Nov'),1,2)
Some thing like this ?
Thanks,
Srihari
Hi Srihari,
Use
=If(Match(MonthName, 'Nov', 'Dec') > 0, 1, 2)
That should work.
Thank you Baeyens.
Thats working.
Thanks for getting me thorugh Deepak and Baeyens.
Have a nice day !