How to calculate if X is +2 or -2 of N

[grumbachr]

I have a fairly large Let/Case calculation but I've been asked to change it slightly. I hope it doesn't get broken by this.

I've been asked to evaluate if Field A is +/- 2 of Field B. I've never written any calc using this concept first can it be done, can I just add it to the case without adding fields or do think I need a field?

Sorry if this is not explained well.

[comment]

I am not sure what your question is. The test itself could be simply:

Abs ( FieldA - FieldB ) ≤ 2

[grumbachr]

Thanks let me try with a few examples. I need to know if FieldB is + 2 of FieldA or if FieldB is -2 of FieldA

Record1- FieldA = 15 FieldB = 18 15-18 = -3 not within 2

Record2- FieldA = 14 FieldB = 13 14 -13 = 1 is within 2

Record3- FieldA = 12 FieldB = 13 12-13 = -1 is within 2

I first read that Abs had to be a positive number but it "returns" a positive number so that might work.

I'll tinker thanks.

[comment]

Abs ( 15 - 18 ) ≤ 2 returns False.

Abs ( 14 - 13 ) ≤ 2 returns True.

Abs ( 12 - 13 ) ≤ 2 returns True.