Forum Discussion
DIVIDE function when dealing with 2 zeroes
Hi all ! I have a discrepancy measure whose value is : Discrep :=
1
- DIVIDE ( ABS ( A1 - B1 ), A1, 1 ) So it should return 0 whenever A1 is equal to 0. But here, when I come to check...
divide(null,null,1) = null is more or less what's happening. If there's nothing to divide, it returns nothing.
How about this instead?
Discrep :=
VAR quotient = DIVIDE ( ABS ( A1 - B1 ), A1, 1 )
RETURN
IF ( ISBLANK ( quotient ), 0, 1 - quotient )
divide(null,null,1) = null is more or less what's happening. If there's nothing to divide, it returns nothing.
How about this instead?
Discrep :=
VAR quotient = DIVIDE ( ABS ( A1 - B1 ), A1, 1 )
RETURN
IF ( ISBLANK ( quotient ), 0, 1 - quotient )
Works like a charm, thanks a lot ! Learned something today.