on 05-21-2009 3:54 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What about if I have 2 fields across that have to be added together to get a line total?
I can't add the 2 formulas at the end. Iow, I have this formula
WhileprintingRecords;
Numbervar q1;
q1:=q1+ (sum ({@Quoted 1}, {Command.CUSTNAME}));
q1;
I have 4 of these, q1-q4 and also 4 b1-b4 for the whole line.
These work but I need to add them all up for an across line total.
need to sum fields across the line in one case and max in the other case..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.