If statement not reading periods prior to forecast start
I was wondering if someone could help with below.
if statement not reading dates prior to forecast start period.
Forecast start period is Mar -19
Below should return 0 rather than Mar -19, why is the if statement not reading the first part of the statement?
What do I need to change to get it to work?
IF PERIOD(Asset Acquisition date) + Asset life < Cal Start of timeline THEN 0 ELSE Asset life
Asset Acquisition date (20-08-2014) - Date formatted with a date prior to forecast start period March-19
Asset life- Number formatted - 28.63
Cal Start of timeline - Time period - Month formatted - Set to March -19.
The statement is returning 28.63 instead of 0.
Thank you for helping out.