AnsweredAssumed Answered

Calculation

Question asked by sweetcuda on Feb 12, 2009
Latest reply on Feb 26, 2009 by ninja

Title

Calculation

Post

I am trying to have my filemaker do a calculation but am not sure how to go about it.

I have a table with Different charge codes, and then another table for receipts and the  amount for each receipt. There is only one  charge code that needs to be calculated to have a 5% of the amount charged. 

 

So here is an example. 

I have a receipt for $45.00 i enter it into my database and it is coded to charge code 008, now charge code 008 requires a 5% charge on top of the 45 dollars but none of the other charge codes do. So I want to have a field that will only calculate 5% onto the amount of the receipt if the 008 charge code is used. 

 

Thank you for your help,

Lesley

Outcomes