Forum Discussion
RMDNA
Solution Sage
Solution SageInfinity, 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...
Greg_Deckler
Community Champion
Community ChampionCan 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.