For example FileMaker outputs 25 as the answer to -5^2, but the correct answer is -25

- On FileMaker Pro Advanced 17.0.1, macOS High Sierra 10.13.4
- To replicate: Create the following expression in Data Viewer: -5^2. It'll give you 25, but it should be -25. Exponentiating a negative number by any even exponent will give you the wrong answer. FileMaker appears to assume -5^2 is (-5)^2 but that assumption is wrong in mathematics. FileMaker should be following the rules of math, as that's what developers expect.
- Exponentiating by an odd number works, oddly enough. FileMaker outputs -125 for -5^3, which is correct. It's only even exponents that don't work, like -5^2, -5^4, etc
- Workaround: Change the negative number to a positive and multiply by -1. For example, change -5^2 to -1 * 5^2

Edit: Moved things around a bit for clarity

Jeremiah_Hammond:

You said,

-(5)^2 and -1 * (5)^2 are the same.

Incorrect. -(5)^2 and (-1 *(5))^2 are the same.

Enter the same equation into Excel and/or Numbers. The result for -(5)^2 is +25.

TSGal

FileMaker, Inc.