Inserting a Summary Field Into a Group Footer

[HRISUser]

I have created a report that has a lot of lines per employee and what I am trying to do is suppress the details and show only the summarized fields in the group footer section.

The problem is that when trying to insert a summary the formula field that I created is not showing up as a possibility to be selected. I was looking through the help and it said that it might be because it is a date field, but where I'm confused is that I have summarized dates before.
Here is a date formula field that is working:
IF {PATRNHIST.COURSE} = 'WCT' THEN {PATRNHIST.DATE_COMPLETED}
I have a Maximum summary field operating properly off of the above field.

But this is the formula field that is not allowing me to summarize:
IF {PERSACTHST.ACTION_CODE} = 'POS CHANGE'
AND {PERSACTHST.REASON_01} = 'P2-CHGPROM'
THEN MAXIMUM({PERSACTHST.EFFECT_DATE})
ELSE {EMPLOYEE.ADJ_HIRE_DATE}

The summary that I want to do is insert the Maximum of the Second formula field in the group footer.

Any help would be GREATLY appreciated.
Thanks

 

[lbass]

You can't insert summaries on formulas that contain summaries. The following might give you the result you seek:

IF {PERSACTHST.ACTION_CODE} = 'POS CHANGE'
AND {PERSACTHST.REASON_01} = 'P2-CHGPROM'
THEN {PERSACTHST.EFFECT_DATE}
ELSE {EMPLOYEE.ADJ_HIRE_DATE}

Then insert a maximum on this formula.

-LB