Skip to Content

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

Summing a column of Max fields

I have a report that has columns of fields that are themselves inserts but a Max for that field. Now they want this summarized. I am not getting the right results. SHould I be using whilePrintingRecords formula or some other feature? How do you use WhilePrintingRecords like that?

The problem is that this type of field this Max, cannot be summarized. I tried to make such a formula to sum and it is not allowable.

I can't get this column to summarize. What I want to do is for each line, take the Summary Max and out it in a grand totals bucket and print this at the end.

Former Member replied

Hi,

Try the following formula :

WhileprintingRecords;

Numbervar x;

x:=x+Max(fieldvalue);

x;

Place this formula in your detail / group where you have max field and place the below formula in your grand total :

WhilePrintingRecords;

Numbervar x;

x;

Thanks,

Sastry

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