Forum Discussion
Values comparision number to text
The data type of column [Valid Price] cannot be whole number or decimal if you have any rows with "Contract Not Yet Started". It would have to be text. I guess you don't have any rows that have that value?
It is not allowed to compare text and numbers.
Maybe use a number code for "CONTRACT NOT STARTED", like a negative number that I guess wont come up in prices?
I tried below,
Start Date = IF([Valid Price]=" ","N","Y")
but getting the same error.
Sure, you're still doing the same, comparing a number to text.
You could use the query editor to easily replace all occurrences of your text string with a number
Hi AIB,
problem is that VALID PRICE is a calculated column and i am not able to see in QUERY EDITOR.
Hang on, I'm getting confused here. If it's a calculated column, how have you been able to create one with numbers and text? What type is that column?