Skip to Content

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

Grouping with A formula issue

I am grouping on a date that was calculated using the following formula :

local stringvar d:= {TAGDTL.USER_DEF_TEXT_1}; //or database field

numbervar y:= tonumber ( '20' & d[5 to 6]);

numbervar m:= tonumber ( d[1 to 2] );

numbervar dd:= tonumber ( d[3to 4] );

date( y, m, dd)

The date displays fine, however when I group on it, it appears that it ignores the date completely.

The data in the detail shows up

10/14/2008

10/15/2008

10/16/2008 etc

however the group shows up with a completly different date.

Group = 10/12/2008

detail = 10/14/2008

detail = 10/15/2008 etc....

any ideas? Suggestions? help?

Thanks,

Jim

Former Member
Former Member replied

Hi James,

Yes,. you will have to create a formula and insert the same in your report. I believe you are not using your database field in your report in any of your sections.

You can check by placing your database field and formula side by side in your report.

Do you have multiple groups in your report ?

Thanks,

Sastry

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