Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
need a total for only the last load of orders. What's the best way to get the last date. The Max ALL is not working.
Sum({<[Order History Import Date]= { '=Max(ALL [Order History Import Date])'} >} [Order History Open Dollars])
just try:
Sum({<[Order History Import Date]= { '$(=date(Max(ALL [Order History Import Date])))'} >} [Order History Open Dollars])
Try this
Sum({<[Order History Import Date]= {'$(=Max(TOTAL [Order History Import Date]))'} >} [Order History Open Dollars])
OR
Sum({<[Order History Import Date]= {'$(=Max([Order History Import Date]))'} >} TOTAL [Order History Open Dollars])
May be this:
Sum({<[Order History Import Date]= {"$(=Max({1} [Order History Import Date]))"}>} [Order History Open Dollars])
please post a sample application to demonstrate
thanks
regards
Marco