have you tried
IF if datetrunc('day'',date)) <= datetrunc('day',today()) and
[data_type]='actual' AND [Cal_Date_New]='Current' THEN [pipeline]
where date is whatever your actual date is -- cal_date_new?
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.