Iferror formula

Hi, 

 

I'm trying to do a calculation similar to the IFERROR calculation in excel but I can only seem to do the IFTHEN formula in Anaplan. Does anyone have a suggestion for this?

 

The excel function is IFERROR(X/Y, 0)

 

Thanks,

Tom

Best Answer

  • If it's a divide by zero error you're trying to handle you could just do IF Y = 0 THEN 0 ELSE X/Y

Answers

  • Can you give an example of an error that you are trying to catch