FirstSortedValue is not returning single value in set analysis.

[#1]

Hi,

The FIrstSortedvalue is not working in this expression....If used alone it returns single date but it seems it is return NULL in set analysis..

Sum(Aggr(If(MonthName(Min({1}TxnDate)) = 'May 2013'), Sum({<TxnDate={$(=Date(FirstSortedValue((TxnDate), Aggr(Min({<TxnType={'Invoice'}>}TxnDate),CustomerListID, TxnDate))),'MM/DD/YYYY')}>}Amount), 0), CustomerListID))

Any idea?

Saurabh

[#2]

What about this expression in textbox?

$(=Date(FirstSortedValue((TxnDate), Aggr(Min({<TxnType={'Invoice'}>}TxnDate),CustomerListID, TxnDate))),'MM/DD/YYYY')

??

regards

Darek

[#3]

Hi Darek,

BOth expressions  work in textbox but they do not work when i used them in expression....

BTW..is it possible to use the value of textbox in a expression.?

[Anonymous]

Hi, Ramya.

Try encircling the $() in single quotes:

Sum(Aggr(If(MonthName(Min({1}TxnDate)) = 'May 2013'), Sum({<TxnDate={'$(=Date(FirstSortedValue((TxnDate), Aggr(Min({<TxnType={'Invoice'}>}TxnDate),CustomerListID, TxnDate))),'MM/DD/YYYY')'}>}Amount), 0), CustomerListID))

Hope it helps.

[#5]

Nope!
It did not work..