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

    Sum values based on a count in an expression

      Hi,

       

      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!