Iferror formula



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)




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


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