Summary of a Calculation Field

[FM-Newbie]

Hello From a FM Newbie.

I'm looking to build a report but I need to add a calculation with a summary field.

I added a new field called "Orders" that is a calculation / number with field STORE_ID=1

Next, I added a new field called "Order Total" that is a summary / count of.

Next, I added a merge code for "Order Total" to a part sub-summary to a report but the result are given all orders from the field STORE_ID regardless if STORE_ID=1 or STORE_ID=2.

[Agnes Riley]

What are you trying to do, tally up orders for a time period? Can you please explain what you're trying to a hi everyone and post screenshots?

If you use a subsummary, you'll have to sort the records so it'll show the result. So if you want order to allow per store then you'll have to sort the records by store ID.

[FM-Newbie]