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!