AUGForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Course
  • Consulting
  • Login
  • Register
Acumatica Forums

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

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Acumatica Report De...
Grouping by Quarter...
 
Notifications
Clear all

In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Sincerely,
Tim Rodman

Questions Grouping by Quarter & by Field Values

Acumatica Report Designer
Last Post by Tim Rodman 2 months ago
2 Posts
2 Users
1 Likes
134 Views
RSS
Laura Carpenter
Posts: 10
 Laura Carpenter
Topic starter
December 7, 2022 8:31 am
(@lauracarpenter)
Member
Joined: 2 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: 2957
 Tim Rodman
Admin
December 14, 2022 11:59 pm
(@timrodman)
Member
Joined: 7 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
  • 11 Forums
  • 2,236 Topics
  • 9,868 Posts
  • 7 Online
  • 1,812 Members
Our newest member: Heather Jones
Latest Post: Sales Order Comment Lines / Memo / Note Lines
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

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2023 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×