Use IF text lookup in a numeric formula
Hi, I have a numeric formula that calculates the amount of hours that have passed if a date/time exceeds 24 hours. If([Delivery (hours)]>24,[Delivery (hours)]-24) I would like to add the cond...
Forum Discussion
I figured it out. It's that "AND" is capitalized. I made them lowercase and now it lets me save the formula without errors.
I had no idea that this could cause conflict. Good to know.
I had no idea that this could cause conflict. Good to know.
Unfortunately it highlights functions with incorrect capitalization, such as isnull would be highlighted as it will be corrected to IsNull on save. or dbid() will be highlighted. So those syntax "errors" which will be corrected when the formula saves should not be flagged as warnings.