By using this website, you agree to our Terms of Use (click here)
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
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.
Try joining to the DateInfo table 😀