Multi-Row Formula producing negative numbers

Question

I have a list of N records (only 1 field) and am dividing the (N+1)th record by the Nth record for all N>1. For N = 1, I set the value to 1. Here is my expression:

IF [Field1] = 1  THEN [Field1] = 1 
Else [Field1]/[Row-1:Field1] ENDIf

The output is correct except all the numbers are negative. Any ideas why?

JohnJPS · Accepted Answer

THEN "[Field] = 1" produces -1, since [Field] does not equal 1.  Just put [Field] there.  :-)