Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

group by qtr

i am using the following to create a group by qtr.

if {NYP_pal_care_rpt;1.ADMIT_DATE} in Calendar1stQtr then 'QTR1' else

if {NYP_pal_care_rpt;1.ADMIT_DATE} in Calendar2ndQtr then 'QTR2' else

if {NYP_pal_care_rpt;1.ADMIT_DATE} in Calendar3rdQtr then 'QTR3' else

if {NYP_pal_care_rpt;1.ADMIT_DATE} in Calendar4thQtr then 'QTR4'

if the end user selects the previous year i would still like to create a group by qtr for the previous year.

i dont see anything just for qtr1 etc. anyone know how i can accomplish this?

Former Member
Former Member replied

Just use the DatePart function instead...

DatePart("q", {NYP_pal_care_rpt;1.ADMIT_DATE})

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question