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

    cumulative calculation


      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?