AnsweredAssumed Answered

Table calculation problem

Question asked by globe11123 on Jul 18, 2016
Latest reply on Jul 18, 2016 by globe11123

1.png

I'm using the above calculation to differentiate the units in our system. Anything after serial number 19653 and the given product codes will be a revision Unit.

 

For some reason Revision is showing up on serial numbers less than 19653. What's wrong with this calculation?

 

Is there a better way to do this IF statement?

Outcomes