2 Replies Latest reply: Sep 6, 2018 3:42 AM by Punam Wagh RSS

    help on concatnate the two fileds?

    daisy ch



      I have ActionID and RiskID.


      if I write expression Count(distinct ActionID) output is 100 example

      if I write expression Count(distinct RiskID) output is 100 example.just assume.


      when I write the expression count(distinct ActionId&RiskID) the out put showing 600 something.


      if write the individual output 100 and 100.but using concatenate showing more value .


      1. way is showing more value.is there any other way concatenate the two fields.