I'm using the following piece of ampscript:
Occasionally, a non-numeric piece of data is added to the @BillAmount (assumption, not 100% sure yet). When this happens, the the whole journey stops due to the following error:
ExactTarget.OMM.FunctionExecutionException: An error occurred when attempting to evaluate a FormatNumber function call. The input value () cannot be formatted as a number. The first parameter value for a FormatNumber call must be a numeric type supported by the requested format. Value: Format: F0 Error Code: OMM_FUNC_EXEC_ERROR@ - from OMMCommon
Assuming I can't fix the bad data coming in, is there a way I can structure the ampscript to skip this if the data isn't numeric? Trying to fix this so the whole journey doesn't conk out in this edge case.