2 Replies Latest reply on Jul 2, 2010 2:20 AM by TS_alphabeta

    Calculation Fix



      Calculation Fix


      Here is what I tried.


      If ( Goals Employee ID::Status = "unpaid" )Sum ( Goals Employee ID::Amount To Pay )


      Trying to get the total sum of all lines with unpaid in the Status field

        • 1. Re: Calculation Fix


          I think there is a fault in the formula

          If( Goals Employee ID::Status = "unpaid" ) ; "Sum( Goals Employee ID::Amount To Pay );"" ) But I don't think it will work!

          I think using a subsummary field that is a sub total of the Amount to pay sorted on the date or employee

          It should be part of a script that finds "unpaid"

          These are some pointers


          • 2. Re: Calculation Fix

            I would do it a bit differently. Create another instance of your Goals Employee ID table and call it Goals Employee ID 2  and relate to your original Goals Employee ID using the Status Field.

            And then create a field with the calculation (Total amount to pay):

            If (Status="unpaid" ; Sum ( Goals Employee ID 2::Amount To Pay ) ; "")

            Hope this helps :)