This content has been marked as final. Show 2 replies
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 .