AnsweredAssumed Answered

Diferent calculations in a field

Question asked by dhowbad on Oct 26, 2017
Latest reply on Jan 17, 2018 by dhowbad

I am lost to the logic of trying to have a different calculation field for each different record.  I have a file of Vendors.  Each vendor calculates a rebate differently.  So I'd like to have a calculation field that is different for each vendor in a table.  I've played around with having a relationship to the vendor with a table that is related by vendor id, but can't seem to make that work.

 

Example;

Vendor #1 has a calculation field that = (field 1 - field 2) * field 3

Vendor #2 has a calculation field that = (field 1 + field 4) * field 3

Vendor #3 has a calculation field that = field 5

.... and on for about 130 different ways of calculating a rebate

 

Using Mac on FileMaker 15

 

Thanks in advance for any help!

Outcomes