5 Replies Latest reply on Jan 22, 2013 10:54 PM by xyrejeddiah

    multiply field value if  it has four decimal places

    xyrejeddiah

      Title

      multiply field value if  it has four decimal places

      Post

           Hi,

           I'm trying to create a calculated number field named "RESULT" the reference number field is "AREA" which contains values measured in hectares and sq.m. without symbols. Now i want to happen is if "AREA" value has four decimal places multiply it with 1,000 but if not just return the AREA value.

            

           Thanks...