I have a report that is grouped in a specific order (Group names that describe what Inv ID is used for) by Item ID and then grouped again to get a group footer based on Item ID within the group names.
I have a formula called @Cost On Order that multiplies qty ordered by unit cost. This formula is added to the group footer of the 2nd group and shows the correct amount.
My issue is when trying to do a Running Total based on this formula to show in the footer of Group 1 (Trying to show total $ amount on order for each named group) my total is lower that Group 2 amount.
IP Logged