I have 3 fields. The CAP field and the 3rd Qtr YTD are currency fields. The third field is Alert and is a text field.
I want to have the Alert field results based upon a calculation using the CAP and YTD fields. If the YTD field is greater than 89.99% of the CAP I want the Alert field to display the word "Alert". Otherwise it would display "Okay". Here is my current expression which so far result in the record displaying #NAME".
=IIf([3rd Qtr YTD>".89999*CAP"],[Alert],[Okay])
Can someone point out the error of my ways?