complicated calculation

Hubertus · Post by **Hubertus** » Thu Jul 20, 2006 5:18 pm

I have Delivery --> Order --> OrderDetails <-- Product (--> means 1:N)
I need to summarize the amount from OrderDetails by Product for a whole Delivery. With these amounts (1 for every product) I'd need to calculate ceiling(sum/1000). And finally I need to sum up the results from the ceiling function calls and place it into Delivery

Can this be done with AwareIM ?

Thanks a lot for any hints,
Hubertus

aware_support2 · Post by **aware_support2** » Fri Jul 21, 2006 6:15 am

Hubertus,

You need to add a non-persistent object DeliveryProduct and a rule to object Delivery with the following actions:

FIND Product WHERE EXISTS OrderDetails WHERE (OrderDetails.Order.Devlivery = Delivery AND OrderDetails.Product = Product)

FOR EACH Product CREATE DeliveryProduct WITH DeliveryProduct.Delivery = Delivery, DeliveryProduct.CeilingTotal = CEILING(SUM OrderDetails.Total WHERE (OrderDetails.Order.Devlivery = Delivery AND OrderDetails.Product = Product) / 1000)

Delivery.CeilingTotal = SUM DeliveryProduct.CeilingTotal WHERE (DeliveryProduct.Delivery = Delivery)

Hubertus · Post by **Hubertus** » Fri Jul 21, 2006 6:33 am

wow, thanks !
I was expecting a hint, not a solution