Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
try set Analysis
sum({<version={'$(=max(version)'}>}amount
it didnt work
sum({<VersH={'$(=max(VersH)'}>}LineAmountA)
edit:
money(sum({<VersH={$(=max(VersH))}>}LineAmountA))
works now without '..'
can you post how your Detail data looks like and what should be expected result?
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?
sorry I donot understand your requirements
can you post a small example application?
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 | |||
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
nearly..
what I need to sum is not 74.
I need:
3+3+45+5+6=62
aggr(max(Amount),KeyNr)