Hey guys, have a currency formula in search, returning a price, it says : {fxamount}/quantity} but today I got a divide by zero error. Usually I wrap it around NULLIF, however it didn`t help. I came up with the following :
CASE WHEN
NULLIF({fxamount}/{quantity}, 0) !=0
THEN NULLIF({fxamount}/{quantity}, 0)
ELSE NULL END
It still gives divide by zero error
Any clues ?