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,