Hey guys, have a currency formula in search, retur...
# suiteanalytics
c
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 ?