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

    help on concatnate the two fileds?

    daisy ch

      Hi

       

      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.

       

      Thanks