7 Replies Latest reply: Mar 17, 2017 4:53 AM by Sunny Talwar RSS

    Set Expression Question

    Jason Salisbury

      Assuming the following data:

       

      QuoteVersionTotal
      A1$500
      A2$1000
      A3$700
      B1$1200
      B2$800
      C1$900

       

       

      I was trying to create a Measure that would only calculate the Total from the MAX version, so in this case $700, $800 and $900 and display them in a table like this:

      QuoteTotal
      A$700
      B$800
      C$900

       

       

      But my formula isn't working. I thought the formula would look something like this:

       

      Sum({<Version=Max(Version)>} Total)

      or

      Sum({<Version={Max[Version]}>} Total)

       

      The top formula doesn't give me a value. The bottom gives me $0 every time. What am I doing wrong? Do Set Expressions work in Tables?