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

    Max date for Net Brokerage

      Hello

       

      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.

      John