Iferror formula

tomflahavan
Occasional Contributor

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

1 ACCEPTED SOLUTION

Accepted Solutions
GeorgeDuckett
Regular Contributor

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

View solution in original post

2 REPLIES 2
GeorgeDuckett
Regular Contributor

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
anirudh
Community Boss

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