I am trying to make a summary in Monarch Data Prep Studio where I compare debits to credits to make sure they balance. I have a summary that has columns for the account number, the debit value of the account, the credit value of the account (which should be the same value with the opposite sign), and lastly a column made by the summary that sums the debit and credit. What I want to do it look at the sum of the column that sums the debits and credits and make sure the whole thing goes to 0 thus proving that all of those accounts balance. Unfortunately, when I sum the debits and credits I get a small, non-zero residual value. How can I configure the summary to round very small values? When I sum 8147.22 and -8147.22 I should get 0, not -1.81898940354586E-12. When I go to edit the sum column in measures Monarch Data Prep Studio it does not give me the option to use a custom formula; I can only select from their list of aggregations. In Monarch Classic making a summary gives you the option to round calculated fields to a certain number of decimal places; this functionality would solve my problem if only I could find it in DPS.
