x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 2 replies
  • Subscribers 144 subscribers
  • Views 2112 views
  • Users 0 members are here
Browse Forums
Sage 100 Contractor Announcements
119
topics
57
replies
Sage 100 Contractor General Discussion
1k
topics
4k
replies
Sage 300 CRE Announcements
168
topics
526
replies
Sage 300 CRE General Discussion
3k
topics
9k
replies
Sage Construction Management Announcements
4
topics
0
replies
Sage Construction Management General Discussion
17
topics
21
replies
Sage Estimating Announcements
39
topics
3
replies
Sage Estimating General Discussion
189
topics
448
replies
Jim Schuett

How to write SQL statement for percentage in subtotal and total rows?

Posted By

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!

Parents
  • 0

    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.

Reply
  • 0

    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.

Children

*Community Hub is the new name for Sage City