Comparing two Status

[wangui1981]

I have a report showing orders that have been delivered.However in one order i have one item that has been delivered and another that is yet to be delivered.I need to show that if an order contains both delivered and undelivered itens then the status of that order should be Undelivered else if all items in the order have been delivered then the status of the order is delivered.
How do I write this formula?

 

[IanWaterman]

Use a formula

@status

If (statusfield} = 'undelivered' then 1 else 0

Then in Order group footer, use formula

@orderStatus
If sum({@Status}, OrderNoGroupField) >0 then 'Undelivered'
else 'Delivered'

Ian

 

[wangui1981]

Thanks Ian that worked.
Now there is this other situation where i get the difference between the date of order and delivery in days.How can I write a formula showing if the goods have not been delivered then the delivery date is blank hence the status is "Undelivered" else show the difference between order date and delivery date.Iam already able to get the difference in dates.

 

[IanWaterman]

@DeliveryDate

If isnull{DeliverDate} then 0
else
datediff("d", {orderdate}, {Deliverdate})

Ian