Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day!
How i can get latest date with added condition?
For this table i must get latest date, where the quantity > 2 (09.11.2013)
date | Quantity |
12.11.2013 | 2 |
09.11.2013 | 3 |
08.11.2013 | 4 |
07.10.2013 | 6 |
06.10.2013 | 8 |
Thank you!
but my task is to get max date, where quantity > 2 !!!!!!!!!!!!!!!!
(09.11.2013)
hi
so you can use max({<quantity={">2"}>}Date)
or
max(aggr(if(sum(quantity)>2,Date),Date))
({$<Account>'2'>}'vMaxDate')
it will display max date for account>2
Hi
try this
Date(Max({<Quantity = {">2"}>} date),'DD/MM/YYYY')
you will get the O/P as 09/11/2013