Allow Failed Calculations to Output a Value Rather Than 'Calc Failed'
As an AF Asset Analytics user, I would like there to be an option to output a value rather than 'Calc Failed' if an analysis fails to evaluate. I have several aggregate analyses which are dependent on other analyses (which will occasionally fail (which I expect)). When these lower level analyses fail, I would like to have the option of setting the output of the failed analysis to 0 (or some other value), so that the higher level analysis may continue to function properly (instead of failing as well).
Agreed, similar to the iferror function in excel. You could nest another calculation or some value. We have many analyses like this when we are calculating efficiencies (just to give one example). If you have a zero in the denominator, it fails. This is expected sometimes, and so we end up having to determine every expected scenario that ends in calc failed and nest if functions to deal with them.