3 Replies Latest reply: Nov 11, 2015 6:04 AM by Semusa James RSS

    Sum values based on a count in an expression



      With the following expression I simply count values based on some string values of the dimension data:


      =count({$<data={'value a', 'value b'}>}profile.id)


      However, I want to sum these two values in this expression and not through the 'expressions - Full Accummulation', or the 'Total Mode - sum of rows'.


      I tried it with rangesum and aggr, but with no success. Can anyone help?


      Thanks in advance!