Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
try this
count(if(isnull(Date_of_Delivery),cost),total)
Try below in Load Script,
Total - if(not isnull([Date of delivery]) or len([Date of delivery])>1 , Cost) as Profit
Hi Ameen,
May be like below:
if(not isnull([Date of delivery]) or len([Date of delivery])>1 , Total - Cost) as Profit
Thanks,
Arvind Patil
You could use:
if(date_of_delivery, total - cost, 0) as [Profit of deliveries]
- Marcus
I ended up using if(isNull(dateOfDelivery,'Not Delivered','Delivered')
Thanks a lot