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

Tags

Modeling

Calculation Functions

Accepted answers

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

All comments

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

Quick Links

Can you help?

Unanswered questions

ADO Certification - Cannot Create Migration Link
Hi - I cannot seem to create a migration for Assignment 3 and it will not allow me to update the hierarchy and proceed further. It seems to think that a link has already been created, but I don't see anything. Any ideas?
How can i export accuracy metrics from Anaplan Forecaster to Model.
There was an error rendering this rich post.
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…