sum(Amount) with lastest version of every Key

[#1]

Hi Guys,

can you tell me, how can I use sum(Amount) by KeyNr, within the last version of it in backend?

I want for example sum(amount) all KeyNr from periode january to july ..

like:

sum(amount)->within only max(version)

[Anonymous]

try set Analysis

sum({<version={'$(=max(version)'}>}amount

[#3]

it didnt work

sum({<VersH={'$(=max(VersH)'}>}LineAmountA)

edit:

money(sum({<VersH={$(=max(VersH))}>}LineAmountA))

works now without '..'

[Anonymous]

can you post how your Detail data looks like and what should be expected result?

[#5]

Now I have the problem, that the versionnr arent the same, by keynr ..

some keynr has version 5 as max, other version 3 as max(version),

so how can I set all max version of several keynr?

[Anonymous]

sorry I donot understand your requirements

can you post a small example application?

[#7]

Keynr	VersH	max(version) of each Keynr->sum(LineAmountA)
1	2	3
2	4	3
3	5	45
4	6	4
4	7	6
5	4	4
5	5	4
5	6	5

this is the table what I#ve got:

if I use :

money(sum({< VersH={$(=max(VersH))}>}LineAmountA))

It only shows/sum the key within max(versH) --> in this example =7

..

so, how can I sum all the key with their max(Versh) ?

to get this:

Keynr	VersH	sum...
1	2	3
2	4	3
3	5	45
4	7	6
5	6	5

[Anonymous]

I used a small inline table with your data and I got your final table

please have a look if that's what you want

[#9]

nearly..

what I need to sum is not 74.

I need:

3+3+45+5+6=62

[robert_mika]

aggr(max(Amount),KeyNr)