AnsweredAssumed Answered

IF Statement Question

Question asked by andrewma on Mar 15, 2016
Latest reply on Mar 15, 2016 by BillisSaved

I have one field of repeating values that will all be numeric values such as 0, 1, 2, 3, etc...

I am trying to perform a test to do something if the value in a specific repetition is greater than zero, but if it is equal to zero do nothing.

 

The portion of the macro I'm having issues with looks like this:

 

If [Field1[1] ≠ 0}

  Set Field [Field2; 99]

End IF

 

In the example above, if the value in the first repetition of Field1 is 0 I would expect it to do nothing.

If it is any value other than 0 I would expect it to set Field2 to 99.

 

When in reality it is setting Field2 to 99 regardless of the value in the first repetition of Field1.

 

 

(And please no comments regarding my use of repeating fields, i'm only trying to figure out why the logic doesn't work).

Outcomes