firstsortedvalue

[#1]

I am using this expression below to retrieve the last amount corresponding my selection criteria and it is working fine when i select one client

firstsortedvalue({<Year={'$(vMaxYear)'},Date={'<=$(vMaxDate)'},Month=,Day=,MonthYear=>}Amount,-Date)

My problem i don't knwow how can i have the sum of all clients ?

Can you help me Please

It is very Urgent.

Slim.

[whiteline · Accepted solution]

Hi.

To iterate through all clients you can use aggr() function. Then use sum(), with set expression if needed.

For example:

=Sum(aggr(firstsortedvalue(...), Client))

[#3]

Hi,

Many Thanks , it is working very well.

Regards,

Slim.