firstsortedvalue and P()

[#1]

How can I combine these:

avg(aggr(firstsortedvalue(value,-date),Client))

Client = P({1<order={2}>} Client)

Hope someone can help!

liivi

[Anonymous]

Did you try this?

avg({<Client = P({1<order={2}>}>} aggr(firstsortedvalue(value,-date),Client))

[MarcoWedel · Accepted solution]

Hi,

maybe one solution could be:

=avg(aggr(firstsortedvalue({$<Client = P({1<order={2}>} Client)>} value,-date),Client))

hope this helps

regards

Marco