Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Try this:
Sum({<OrderID={"*"}>}ProducePrice)
or
Sum({<OrderID={"=Lem(Trim(OrderID))>0"}>}ProducePrice)
Hope this helps.
I ended up using a Mapping Load/ Apply Map to solve this problem.