Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a simple statement that I need help with.
If [date] field contains '2016', then display as '2016'
If [date] field contains '2017', then display as '2017'
If [date] field contains '2018', then display as '2018'
How do I properly write this up as one expression?
Thanks!
You can enter the following as a chart expression:
=if(OrderDate like '*2016*','2016',
if(OrderDate like '*2017*','2017',
if(OrderDate like '*2018*','2018','Other')))
You can enter the following as a chart expression:
=if(OrderDate like '*2016*','2016',
if(OrderDate like '*2017*','2017',
if(OrderDate like '*2018*','2018','Other')))
Hi
We can remove the nested If statements altogether ...
Try below ::
Pick(wildmatch(OrderDate,'*2016*','*2017*','*2018*',OrderDate),2016,2017,2018,'Other')