6 Replies Latest reply: Oct 20, 2014 12:21 PM by James Butler RSS

    Using the Max function in an expression

    James Butler

      Hi

       

      I'm wanting to sum the value in stock for the last day in the week (to get a closing balance). I thought max would help but i haven't had any luck with the below expression.... Any ideas why?

       

      sum(

      {$<

                  Year=,

                  Week=,

                  Date = {$(=max(Date))},

                  IsTrackedPart = {1}

      >}

      [Inventory Quantity in Stock]

      )

       

      Thanks

       

      James