2 Replies Latest reply on Aug 3, 2017 3:14 AM by beverly

    cumulative calculation

    rasen

      I am preparing database for a project. Background as below:

       

      • Project has Engineers with unique ID.
      • Each ID has specific period of assignment (in months)
      • Each ID has specific rate of billing

       

      Action Taken so far:

       

      • I have created Master table with all experts ID, Position, Manmonth and Billing Rate
      • I have created second table with ID, mammonth used month after month

       

      What I want to Achieve:

       

      • I want to create invoice with following information included;

      1.  ID, Contract Manmonth, Billing Rate, Cumulative Manmonth claimed upto previous month, Manmonth claimed in current month, Cumulative mnmonth claimed upto current month, And balance manmonth

       

       

      Can someone help how to proceed, as I am new to Filemaker?