0 Replies Latest reply on Dec 8, 2011 5:45 AM by amerkfan

    numeric format based on data in another field

    amerkfan Level 1

      I am trying to set up a form where the numeric format of one field is based on units of measure in another field. The fields are: units1 and iq1. What I want to do is have the iq1 field format for percent with two decimal places when units1 is  LS or ls or L.S. or l.s. otherwise the field should be formatted for a number with the format nnn,nnn,nnn.nn. Any help for this newbie is appreciated.