This should should be straightforward but i cannot get the expression to work.
I enter a number of days into a field called DAYS and want to use this number to look up a table of descriptions with the selected description populating a field called PAYMENT TERMS.
I have entered the following expression into the text field called PAYMENT TERMS
=iif([days]=0,"terms are payment on completion",iif([days]=7,"terms are 7 days from date on invoice",iif([days]=14,"terms are 14 days from invoice","invalid number of days")))
I keep getting [#name? in the PAYMENT TERMS FIELD.
What am I doing wrong?
I enter a number of days into a field called DAYS and want to use this number to look up a table of descriptions with the selected description populating a field called PAYMENT TERMS.
I have entered the following expression into the text field called PAYMENT TERMS
=iif([days]=0,"terms are payment on completion",iif([days]=7,"terms are 7 days from date on invoice",iif([days]=14,"terms are 14 days from invoice","invalid number of days")))
I keep getting [#name? in the PAYMENT TERMS FIELD.
What am I doing wrong?