I have a problem now with a maximum function, because every got damn time I get error "This field cannot be summarized".

 

So I am trying to get a maximum out of grouped field.

I am trying to get largest order amount for every year.

Every order have multiple invoices so they have to be summarized first and then try get a maximum out of those.

 

This is the formula that gives error continously.

 

maximum(Sum ({@eur}, {MILLORDEROW.ORDECODE}))

 

So first I have a Group "Year" , that's GH1. After that I have a group called "OrdeCode" which is the group where I have summary out of field called "Invoval".

That {@eur} comes from detail section that is :

 

({BUDGREPO_DET.INVOVAL}*{BUDGREPO_DET.CURRRATE})/1000

 

So it's just amount converted to TEur.

 

The data should look something like this at the end :

 

Group 1 Year for example 2010

OrderCode 1                                 1500

OrderCode2                                  2000

OrderCode 3                                 3000

 

Largest Order for Year 2010 is : 3000 TEur

 

So I would just need the maximum formula to return the value 3000, but I cannot do that cause the field is summarized...hopefully someone could help with this issue.

 

Thank you,

Jyri