How to write SQL statement for percentage in subtotal and total rows?
Getting % on detail rows is no problem, but when trying to get a % on the subtotal or total rows eludes me.
Any help on this would be greatly appreciated. Thanks so much!
How to write SQL statement for percentage in subtotal and total rows?
Getting % on detail rows is no problem, but when trying to get a % on the subtotal or total rows eludes me.
Any help on this would be greatly appreciated. Thanks so much!
Jim - I have written very similar reports for clients, including the percentages on subtotals and totals. Since you are a "consultant/report writer", please contact me at [email protected] for a sample and quote. Hint- you have to look at each formula as "it's own thing"- the div totals cannot simply be the sum of the codes, for example. So I wrote a separate formula. I look at what I need for my totals- not necessariiy the sum of my totals.
Thank you Pam... please see my email to you., Jim
*Community Hub is the new name for Sage City