5 Replies Latest reply: Oct 11, 2017 7:24 AM by Ameen Mahfouz RSS

    How to use IF not null with specific fields?

    Ameen Mahfouz

      I want to create new field in the data

      - Want to name the field as (profit) where I calculate total - cost only if another field which is (Date of delivery is not NULL)

       

      Existing field

      total, cost, date of delivery

       

      Field I want to create: Profit of deliveries

      Basis formula in mind: total - cost IF date_of_delivery not NULL.

       

      Any help with this as I am not a programmer.