Forum Discussion
cannot convert type text to number
Hi,
Im trying to find the price impact by subtracting the "2017 AUP" from the "net unit price (int)(converted). One of the values in 2017 AUP is "No PY AUP," which is giving me the error. Every time I try to subtract it gives me the error that they couldnt convery "No PY AUP" fom type text to type number.
Dylan
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
4 Replies
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
