Forum Discussion

dkehoe32's avatar
dkehoe32
Icon for Helper I rankHelper I
8 years ago
Solved

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 ti...
  • jthomson's avatar
    jthomson
    8 years ago

    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

dkehoe32's avatar
dkehoe32
Icon for Helper I rankHelper I
8 years ago

is there a way to convert it to a null set thats not in the query editor?

jthomson's avatar
jthomson
Icon for Solution Sage rankSolution Sage
8 years ago

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

  • dkehoe32's avatar
    dkehoe32
    Icon for Helper I rankHelper I
    8 years ago

    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.