Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
I got one expression
FirstSortedValue({1<Transactions.TxnDate={If (MonthName(Min({1<Transactions.TxnType={'Invoice'}>}Transactions.TxnDate)) = MonthName(Max(Transactions.TxnDate)), Transactions.TxnDate)}>}Customer.CustomerListID,Transactions.TxnDate)
It is showing error at red colored comma (,) after MonthName(Max(Transactions.TxnDate)) on the second line ...
Regards,
Saurabh
Hi,
try post a sample app.
Hi Ramya,
Try to post some sample and explain what is your expected output.
Try this expression
FirstSortedValue({1<Transactions.TxnDate={'$(=If (MonthName(Min({1<Transactions.TxnType={'Invoice'}>}Transactions.TxnDate)) = MonthName(Max(Transactions.TxnDate)),Transactions.TxnDate))'}>}Customer.CustomerListID,Transactions.TxnDate)
Regards,
Jagan.