Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What about this expression in textbox?
$(=Date(FirstSortedValue((TxnDate), Aggr(Min({<TxnType={'Invoice'}>}TxnDate),CustomerListID, TxnDate))),'MM/DD/YYYY')
??
regards
Darek
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.?
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.
Nope!
It did not work..