Logic like Formula

I have 3 Table. Order, Order Item and Item
Order and Item are Parents, Order Item is the child.

logic : if Order ID’s are similar give me total amount of this order.

Which formula to use and how to do it?


C’mon man, focus on the first one and be patient