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 Employee replied
Try the following formula :
Place this formula in your detail / group where you have max field and place the below formula in your grand total :