Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table containing a Product Code , a Transaction Type and Date associated with the Transaction Type. There could be multiple Instances of the Transaction Type by date.
Example:-
Product Code | Date | Transaction Type |
0001 | 01/10/2017 | ADJ |
0001 | 29/09/2017 | ADJ |
0001 | 27/09/2017 | RECP |
0001 | 15/09/2017 | RECP |
I want to return the latest RECP Date i.e. 27/09/2017 but, if there is no RECP then return the latest ADJ. 01/10/2017
How can I achieve this in a IF THEN statement
Perhaps this?
Only({<Date = {'$(=Min(Date))'}, [[Transaction Type] -= {'RECP'}>} Date)
Hi Anil, Thank you for your speedy response.
This does not appear to cope with multiple RECP's and it does not provide the last ADJ date if no Receipts found.
On what bases, We are going to have for RECCP's??
HI Anil,
Appears to return null values if there is more than one of them ...