Hello team,
I had a workflow which was running fine, I made some changes in the workflow and now running into error.
Note: I have not made any changes to the columns of the formula.
Formula:
IF [data_type]='Forecast' then
(if [fiscal_year]>[current year] then "Yes"
elseif ([fiscal_year]=[current year] and [fiscal_quarter]>=[current qtr]) then "Yes"
else "No"
endif)
elseif [data_type]='Actual' then
(if [fiscal_year]>[current year]-3 and [fiscal_year]<[current year] then "Yes"
elseif ([fiscal_year]=[current year] and [fiscal_quarter]<[current qtr]) then "Yes"
else "No"
endif)
else "No"
endif
Attaching the error:
Both columns (fiscal year and current year) are data type 'double'.. I have also tried this by making this as Int 32, same issue
