Hi, Can anyone help me create a espression for this below business logic?
e.g.
If Forecast Date < today() i.e. 23rd Sep and Prior then outcome should be ‘5) Forecast Missed’,
If Forecast Month = ‘Blank’ then outcome should be ‘6) No Forecast’,
If Forecast Month = today's month i.e. September then outcome should be ‘1) Sep-22’,
If Forecast Month - today's month = 1 i.e. October then outcome should be ‘2) Oct-22’,
If Forecast Month - today's month = 2 i.e. November then outcome should be ‘3) Oct-22‘,
Or else
‘4) >3 Months’
Thanks
