AnsweredAssumed Answered

calculation problem

Question asked by cutykamu on May 7, 2010
Latest reply on May 8, 2010 by LaRetta_1

Title

calculation problem

Post

i’m new to filemaker pro, here is what i’m looking for:

 

i have fields “price”, "charges 1”, "charges 2”, “terms 1”, “terms 2”, "final price"

 

“price" is the price field for example 1.00, "charges 1" i will adding records for example 0.01 or -0.01, “terms 1” i will be using records as A or B terms, 

"charges 2” i will be adding records for example 0.01 or -0.01, “terms 2” i will be using records as A or B terms, 

 

“final price” will be the calculation with “price” + “charges 1” + “charges 2” = “final price"

 

what i want is if my “terms 1” having a record A than “charges 1” should have record 0.01 or if i choose "terms 1” record as b than “charges 1” should have records -0.01 automatically

 

pls help !!!

Outcomes