9 Replies Latest reply on Nov 12, 2019 10:15 AM by Jeremy Locanas

    Why does subtracting a Fixed calculation from another Fixed calculation double the subtraction?

    Jeremy Locanas

      I have a data source linking Bills with Invoices by Invoice #.

      I have two fixed calculation columns:

      1) InvoiceRevenue = { FIXED [Invoice #],[Revenue] : min([Revenue]) }

      and

      2) BillsCost = { FIXED [Bill #],[Total PS Cost] : min([Total PS Cost]) }

       

      both designed to remove duplicate entries from the join.

       

      I then Sum the costs using

      3) BillsTotal = { fixed [Invoice #] : sum([BillsCost]) }

       

      Everything works fine and perfectly when these 3 fields are separate.

       

      But when I create a new column

      4) TrueGP = InvoiceRevenue - BillsTotal

       

      For some reason TrueGP keeps subtracting InvoiceRevenue - (BillsTotal * # of duplicate Revenue lines)

       

      Can someone help me understand why this is happening?

      Thanks!

       

      --

       

      Edited - Added Workbook