AnsweredAssumed Answered

Calculation Based on Item in Value List

Question asked by Jefffriesen on May 11, 2012
Latest reply on May 11, 2012 by Jefffriesen

Title

Calculation Based on Item in Value List

Post

Hi,

I have an invoice type of layout in Filemaker 11 Pro. I want to create an auto entry number in a field called "Total Line one". This would be dependant upon a specific value (i.e. DVD) in a drop down list being selected in my "order type 1" field. I then want to enter a quantity number in the "quantity 1" field. When "DVD" is selected I want a calculation of $8.00 x "quantity 1" to show up in the "total line one" field. I want to set this up for all items in the drop down list to reflect different prices for the item selected.

If "CD" is selected, I want the "totalline one" field to enter the total value of $5.00 x "quantity 1"

If "DVD" is selected I want the "total line one" field to enter the total value of $8.00 x "quantity 1"

If "MP3" is selected I want the "total line one" field to the enter total value of $3.00 x "quantity 1"

Can this be done?

 

Thanks,

Jeff

Outcomes