2 Replies Latest reply on Sep 12, 2019 6:17 AM by Nancy Bolduc

    Issues with using FIXED and IF

    Nancy Bolduc

      Hi,

       

      I am having an issue with the use of FIXED with IF.

       

      I am using a FIXED command to get rid of duplicates. It works fine, here's the calculation:

      {Fixed [Report Type], [Expense Type], [Sent for Payment Date], [Entry Approved Amount],[Vendor] : MIN([Entry Approved Amount])}

       

      FIXED calc.PNG

       

      There are 2 "Expense Type" that I want to exclude, so I added an IF condition:

       

      IF([Report Type] != "tolls" AND [Report Type] != "Taxi")

      then {Fixed [Report Type], [Expense Type], [Sent for Payment Date], [Entry Approved Amount],[Vendor] : MIN([Entry Approved Amount])}

      END

       

      The calculation is valid but it returns all duplicates. So not working...

       

      FIXED with IF calc.PNG

      Can someone please tell me what is wrong with my calculation? ~Thx!