Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a table with a list of dates.
I need the minimum date (31/12/2015) by Document No. in a chart table.
Document No_ | Date | Rem Amt | MIN(TOTAL <[Document No_]> Date) |
-1,633,021.72 | 31/03/2016 | ||
GJPAY00006985 | 31/03/2016 | 12,162.65 | 31/03/2016 |
GJPAY00006985 | 29/02/2016 | 30,046.71 | 31/03/2016 |
GJPAY00006985 | 31/01/2016 | -94,672.09 | 31/03/2016 |
GJPAY00006985 | 31/12/2015 | -1,580,558.99 | 31/03/2016 |
I tried using formula Min(Total <Document No_]> Date). However, I do not get the desired result.
Note there is more there one Document No_ in the chart.
Please help.
Hi,
may be like this
aggr(Min(Total <Document No_]> Date),Document No_)
Try this,
Date(Aggr(Min(Date),[Document No_]))
I don't see any issue with the expression. Would you be able to share a sample where it isn't working for you?