2 Replies Latest reply on May 14, 2014 11:09 AM by W.D.

    Troubleshooting a possible field calculation



      Troubleshooting a possible field calculation


           Hello out there. I am new to Filemaker and have been having some trouble with a project I have. 

           The goal: To make a printable listing of available new AND used products and pricings to hand out to potential customers and clients. I have everything set up except one problem

           The problem: My original layout has 3 fields for pricings; Our Purchase Price (what we paid for it), MAP (minimum purchase price. This only applies to new items), and Our Selling Price. Here is what I need to show up on the new printable layout:

           IF the item is NEW = MAP

           If the item is USED = Our Selling Price

           Is there a way to have one field on a layout to show the appropriate price? Even though most NEW items will have an entry in MAP and Our Selling Price

           I am still learning calculations and scripts, which is what this probably requires. Any assistance would be appreciated. Thanks!