Forum Discussion
Infinity, NaN, and divide function
All, In a custom column, I'm attempting to divide two columns, [Committed] and [Actual] (fixed decimal numbers in the backend, as U.S. Currency), and attempting to get a [% to target] result. The...
Can you post some sample data? Generally, if zeros are involved, use DIVIDE to avoid divide by zero errors. Additionally, use the erd parameter "alternateresult" option of the DIVIDE function to catch divide by zero and return what you want. Potentially wrap it all in an IF statement if necessary.