7 Replies Latest reply: Oct 5, 2015 10:30 AM by Matthew Berry RSS

    Can't find the max/highest number displayed in YTD

    Matthew Berry

      I need help finding the highest number displayed in the 'YTD Var' column of an object.

       

      The dimension = Brand

      The expression = =((Sum($(vSetYTD)Sales))-(Sum($(vSetPreviousYearYTD)Sales)))
      The expression label = ='YTD Var'

       

       

      For example, if the values were 900, 400, and 450, I need to see the 900 in a text box because it is the max/highest value

       

      Thanks!!!!