Forum Discussion
cannot convert type text to number
You could make a calculated column saying newcolumn=if(yourtable[2017 AUP]="No PY AUP",blank(),yourtable[2017 AUP]), but I'm not sure why you would want to do that outside of the query editor
Depends on what your desired outcome is. You could replace the value that's causing the error with a null, or you could put in some conditional logic whereby if the 2017 AUP value is No PY AUP then give it whatever value you need the calculation to be, else do the calculation as normal
is there a way to convert it to a null set thats not in the query editor?
You could make a calculated column saying newcolumn=if(yourtable[2017 AUP]="No PY AUP",blank(),yourtable[2017 AUP]), but I'm not sure why you would want to do that outside of the query editor
That works thanks for the help!
My query editor for some reason doesnt line up so if i were to edit it the query it wouldnt affect my table.
