I have a report that shows Store Information and items ordered the price of the items and the quantity. I want to add in a calculated field to show the SUM() for each store, so my desired output calculations would be
Serial 1111 should produce 830.21
SERIAL 1234 should produce 11.35
SERIAL 2311 should produce 92.38
SERIAL 5555 should produce 46.03
SERIAL 5566 should produce 252.76
However, when I added in the field, as I thought it should be added, this was not produced. I am attaching a sample of my db with garbage data to better allow someone to troubleshoot. How should I set-up the calculate field to do the calculations like I am after?
Database2.zip