Sage 100

Sage 100 4.50, attempting to modify the AR Sales Tax report to add a group by State. I created a formula as Left(TaxCode,1), and added it as a group one level above the TaxCode group. When I run the report, it shows both groupings at the same level. State A Code A100 Code A100 Totals State A Totals = Code A100 Totals State A Code A101 Code A101 Totals State A Totals = Code A100 Totals What I was expecting: State A Code A100 Code A100 Totals Code A101 Code A101 Totals State A Totals = Code A100 Totals + Code A101 Totals Any ideas?

Look at the formula in the State A Totals. Sage might have hard coded the subtotal formula instead of using the Create Summary feature in Crystal.

I tried recreating all the subtotals in Crystal, same results.

If you post the Crystal Report, I could take a look at it.

Here it is

It works exactly as you described it working correctly on my system.

I've done a couple of things with it. I can't get it to not calculate correctly.

@PhilMcIntosh I just ran it on my system and it is working right also? Maybe we need to see the report data that is not looking right to you. Can you do a PDF for us for one state?

Here is the PDF for Alabama

Ah! The problem, is you're subtotaling on the A code before subtotaling on the state (A1500). Move Group 2 to be Group 1 and move the state total to be Group 2. Did any of that make sense?

Like this.

@RobertWood - thank you! I missed looking at the work file sort field.

You're welcome!