Thanks so much. This might be beginning to make sense. I took the name field out of the report for privacy reasons.
The fields I have in my report are:
@Dept (left({Command.PRIOR_ORG_CODE},3) As Dept
Command.Name As Name
Command.Prior_Org_Code as From Org Code
@To Org Code (previous...
Sorry. I tried to attach some jpg. but that didn't work so well. Hopefully this will work beter
https://files.engineering.com/getfile.aspx?folder=d747b1c2-ddce-4827-bc9d-8c44723aac9e&file=Ungrouped_Data.JPG...
I have a report in CR. I have a formula field @Month which takes the Month from a string field ie. 13-Oct-2019 results in Oct. Before I group on that field I have 8 records in "Oct, Nov, Dec, Jan, Feb" several records in some of the months. When I group on the @Month field I only get two...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.