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

— The Forums are now read-only —

— All new activity now takes place here: —

AugForums.com Discord Server
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 4 years ago
2 Posts
2 Users
1 Reactions
1,088 Views
RSS
Laura Carpenter
Posts: 10
 Laura Carpenter
Topic starter
December 7, 2022 9:31 am
(@lauracarpenter)
Active Member
Joined: 6 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: 3204
 Tim Rodman
Admin
December 15, 2022 12:59 am
(@timrodman)
Famed Member
Joined: 11 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,533 Topics
  • 11 K Posts
  • 78 Online
  • 2,437 Members
Our newest member: Matt Butler
Latest Post: Nested SubReport Issue
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

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

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

โ€นโ€บร—

    โ€นโ€บร—