Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have this table :
Table:
Load [Sales Forcast],
date
from table
I want to add a field named Sales_forcast_valid with this condition :
if (today()< date) Sales_forcast_valid = [Sales Forcast]
else
Sales_forcast_valid =0
Thanks for help
if(today()<date, [Sales Forcast],0) as Sales_forcast_valid,