requirement

[Anonymous]

I have an expression:

num(count({$}distinct id)/count({1}total distinct id)),'###.%')

now my id has been split into two: id1 and id2 ,so what will be the correct syntacx to write this

[thevingo]

can you elaborate

[Anonymous]

=num(

count({$}DISTINCT id1)/count({1}total DISTINCT id2)+count({$}DISTINCT id1)/count({1}total DISTINCT id2)

,'###.%')

is it a correct syntax ?

[Anonymous]

can anyone help on this?

[thevingo]

may be stalwar1‌

[sunny_talwar]

So let me understand this... you had this

ID

1

2

3

4

and now it is like this

ID1, ID2

1, -

2, -

-, 3

-, 4

?

[Anonymous]

both ids have the value,

its just that ist been segregated on the basis of some type,

where as in id1+id2 =total id value

I just need to cross check on my set analysis expression

[sunny_talwar]

Hahahaha, I am not sure I understand... is it possible to demonstrate what change with an example (just like how I showed what I interpreted)?

[Anonymous]

your understanding is correct,its like that only

how to write the syntax now?

[sunny_talwar]

Try this may be

Num(Count({$}DISTINCT Alt(id1, id2))/Count({1}TOTAL DISTINCT Alt(id1, id2)), '###.%')