help on concatnate the two fileds?

[daisy1438]

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

[arulsettu]

maybe like this

Count(distinct ActionID)+Count(distinct RiskID)

[PunamWagh]

Hi,

Suppose

ActionID, RiskID

1 ,1       

2,1

3,2

4,2

5,3

1,3

2,4

3,4

4,5

5,5

in above case u will get distinct count of ActionID & RiskID as 5 but u will get count(distinct ActionId&RiskID) as 10

because for each combination there is distinct value.

Wat exactly u want as output