4 Replies Latest reply: Apr 15, 2013 9:48 AM by John Shepherd RSS

    Max date for Net Brokerage



      I am having a problem trying to set a maximum date for the data we have for Net Brokerage. The previous expression worked but since getting Budget data in the dashboard for the whole 2013, I need to get the expression only looking at the maxiumum dates for Net Brokerage data.


      I used this expresison (below) but it is only bringing back the maximum Net Brokerage amount (money) rather than max Net Brokerage date. Please help.



      =sum( {<date = {"$(=Max(Date,'DD-MMM-YYYY'),'DD-MMM-YYYY'))"} >} Net_Brokerage_USD)


                          our date field in the data                                     



      Many thanks.