How to query across tables

[jeckstein]

I am looking to find the sum(ProducePrice) for all the orders.

I have orders and Product information set up into two tables. and they are linked.

How would I create a text box to show the total sum(ProductPrice) of every order.

[sinanozdemir]

Hi,

Try this:

Sum({<OrderID={"*"}>}ProducePrice)

or

Sum({<OrderID={"=Lem(Trim(OrderID))>0"}>}ProducePrice)

Hope this helps.

[jeckstein]

I ended up using a Mapping Load/ Apply Map to solve this problem.