Set analysis for amount

[#1]

Hi guys,

I need to calculate the Amount for the customers with minimum transactions date.

Here is the expression...

sum({1<Date={$(=Min({1<Type={'Invoice'}>}Date))}>}Amount)

But it is not working..

any idea guys?

Saurabh

[eduardo_sommer]

If Iunderstood your expression it will sum all the 'invoices' with date exactly the same as the minimum date in all data. If your date also contains the time, it will also be compared with litle probability of match. I think this is not what you wanted to get.

Please send more details and, if possibl, share the application

Eduardo

[#3]

You understood it correctly ....

my date do not contain time though...

Sharing application is difficult...I will try

It seems to be a simple expression....I am not sure what is wrong here..

[eduardo_sommer]

if the result you want is the sum of the first invoices of all customers,you can use the following expression.:

     sum(aggr(firstsortedvalue(Amount, Date),Customer)
This expression will pick the first invoice of each customer and sum their amounts.

Is this what you were looking for?

Eduardo