AnsweredAssumed Answered

cumulative calculation

Question asked by rasen on Aug 3, 2017
Latest reply on Aug 3, 2017 by beverly

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?