AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica Report De...
Grouping by Quarter...
 
Notifications
Clear all

Questions Grouping by Quarter & by Field Values

 
Acumatica Report Designer
Last Post by Tim Rodman 3 years ago
2 Posts
2 Users
1 Reactions
928 Views
RSS
Laura Carpenter
Posts: 10
 Laura Carpenter
Topic starter
December 7, 2022 8:31 am
(@lauracarpenter)
Active Member
Joined: 5 years ago

I am building a report where I need to group the data first by Quarter then by a group of salesmen.ย  I don't have a field within Acumatica that defines the group of salesmen however I know who is supposed to be in which group.ย  Has anyone had success in doing this with an expression in the grouping settings?ย  I have successfully grouped by the month using the Month (date) function but I can't find anything that will work for the quarter.


1 Reply
Tim Rodman
Posts: 3199
 Tim Rodman
Admin
December 14, 2022 11:59 pm
(@timrodman)
Famed Member
Joined: 10 years ago

Try joining to the DateInfo table 😀ย 


Reply
Laura Carpenter reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,528 Topics
  • 10.9 K Posts
  • 18 Online
  • 2,412 Members
Our newest member: Peter Paasch
Latest Post: Credit Reference Report Needed
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

  • Tim Rodman Julie Baker
Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright ยฉ 2026 ยท AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

โ€นโ€บร—

    โ€นโ€บร—