Division with a negative value

[hendricksk]

I have a simple question; I need Alteryx to divide a negative number. It keeps saying Unknown Variable.

-555.555/1000. Attached is the formula.

[apathetichell]

not sure what's in your data but this erorr isn't related to a negative/positive number.

you have tonumber([field]/1000). if field isn't already a number - this is an error. if it is already a number - no need to wrap it in tonumber.

maybe

tonumber([field])/1000?

do you have a field called k$/period? maybe you mean:

[k$]/[period] (two other fields?)

[hendricksk]

I took the ToNumber out of the formula, there seemed to be still an error. However, I just rewrote the same formula and the error went away. Thank you so much for your help!!