This content has been marked as final. Show 5 replies
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)
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.