#### Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

# Why do negative numbers not work?

edited September 2010
I'm finding killer problems with negative numbers.

For example, this very simple test script:
```Table: Testing
Set: FirstVar=4
Set: SecondVar=2
Set: ThirdVar=-2
FirstVar={\$FirstVar}\n&
SecondVar={\$SecondVar}\n&
ThirdVar={\$ThirdVar}\n&
FirstVar plus SecondVar={! {\$FirstVar} + {\$SecondVar} }\n&
FirstVar plus ThirdVar={! {\$FirstVar} + {\$ThirdVar} }\n&
FirstVar times SecondVar={! {\$FirstVar} * {\$SecondVar} }\n&
FirstVar times ThirdVar={! {\$FirstVar} * {\$ThirdVar} }
```

Generates the following output:
```FirstVar=4
SecondVar=2
ThirdVar=-2
FirstVar plus SecondVar=6
FirstVar plus ThirdVar=(Invalid expression: 4 + -2 )
FirstVar times SecondVar=8
FirstVar times ThirdVar=(Invalid expression: 4 * -2 )
```

Obviously, it can't deal with negative numbers. Has no one found that before? And in the mean time, how do I get around that?

• Simple change, enclose any negative values or variables that might contain a negative number in regular brackets ()

```Table: Testing
Set: FirstVar=4
Set: SecondVar=2
Set: ThirdVar=-2
FirstVar={\$FirstVar}\n&
SecondVar={\$SecondVar}\n&
ThirdVar={\$ThirdVar}\n&
FirstVar plus SecondVar={! {\$FirstVar} + {\$SecondVar} }\n&
FirstVar plus ThirdVar={! {\$FirstVar} + ({\$ThirdVar}) }\n&
FirstVar times SecondVar={! {\$FirstVar} * {\$SecondVar} }\n&
FirstVar times ThirdVar={! {\$FirstVar} * ({\$ThirdVar}) }
```