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

"Azure blob http error" when establish connection between Cloudworks and Blob Storage
I have this error message " Azure blob http error " when i save cloudworks connection to Blob Storage. I follow this link: Connect to Azure Blob | Anapedia Can someone help to identify the root cause and how to resolve? is it related to permission or security?
ADO connection from postgreSQL
Hi everyone, I am trying to create a connection ADO from PostgreSQL, but I consistently receive the following error: Failed to establish a connection The following message was sent from the target system: The SSL certificate is either invalid or not in unencrypted PEM format. Please check your certificate and try again.…
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…