Help "Field cannot be summarize"

[hex6007]

Please help, i want to summarize all the grouptotals i made.
here is my formula:

Whileprintingrecords;
sum(Maximum ({@WeeklyDue}, {@AssignValueToProduct}))

I got an error "field cannot be summarized".

thanks in advance.

 

[jehanzebn]

Morning hex,

What is the formula for weekly due and assignvalueproduct?

Many thanks

Regards

Jehanzeb

 

[Madawc]

In Crystal, you can't summarise anything that is based on more than one detail line. For a grand total, use the same value or formula as you used for the group total.

The use of Crystal totals is outlined at FAQ767-6524.

PS. It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.



Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[Charliy]

Also, are you grouping on {@assignvaluetoproduct}? The second field/formula in a Maximum needs to be something you grouped on.

 

[hex6007]

Hi guys, thanks for the reply.

for Jehanzebn:
The formula for WeeklyDue is here.

if ({@CheckCollectionDay} and {@CheckAccountActive}) then
formula = {LoanSchedule.PayAmount}+{@AServiceCharge}+{@ADecost}+{@ShowSC}+{@ShowDC}+{@INS}+{@CSav}+{@APAF}
else
formula = 0
end if

Then, grouping to {@AssignValuetoproduct} formula is:

if {@TrimProduct}="GL" then
formula = 1
elseif {@TrimProduct} = "SL" then
formula = 2
elseif {@TrimProduct} = "IL" then
formula = 3
elseif {@TrimProduct} = "RL" then
formula = 4
elseif {@TrimProduct} = "PL" then
formula = 5
end if

for Charliy:

yes grouping by {@Assignvaluetoproduct}

 

[lbass]

When asked to show the content of formulas you should provide the content of all nested formulas as well. However, since you have so many of them, please tell us whether you can write this formula without an error message:

Maximum ({@WeeklyDue}, {@AssignValueToProduct})

-LB