12 Replies Latest reply on Jan 22, 2016 7:20 AM by Mike_Mitchell

    not show negative price

    hunterkilla

      I have an excel spreadsheet with delivery costs and some of the costs come back as a negative number so technically we dont have to charge extra to deliver.   I intend to import this about once a month into filemaker overwriting the current price.     I want it so when someone chooses there delivery options if its a negative it just automates it to put 0 and then if its a actual charge to put that in... so is there a way to script if delivery = - then make it 0 else do delivery charge?