Christopher Garcia

Creating a report shows only records with equal fields

Discussion created by Christopher Garcia on Oct 17, 2017

I'm trying to run a report that shows only records that have equivalent Quote Amount and Calculated Quote Amount fields. I know how to define the filter but I can't figure how to say Quote Amount equals Calculated Quote Amount because the numbers vary. How can I do this using SUGAR Professional?


I've thought about creating a checkbox field and using a function that marks it "yes" if Quote Amount equals Calculated Quote Amount, then using that as the defining field, however I can't figure out the correct function to make that work either. 


We've been using SUGAR for a year and I'm trying to clean up the and remove redundant fields. This report will show me which records are suffering from a field redundancy prior to removing the redundant field. 


Thank you for any help!