What does this expression do?

[#1]

I´ve come across this expression in an old qv file I made some time ago - I think I´ve got some help here at that time but I cant figure out

what it actually do

=count(distinct name & 'l' & age)

name and age are fieldnames in a spreadsheet

[#2]

Hi,

this creates concatenation of two field values name, age and | char and counts distinct number of such created strings.

regards

[jvitantonio · Accepted solution]

This will return the distinct count of your concatenated field Name and Age. Let's suppose you have the following names and ages:

NAME -  AGE

Peter  -   20

Peter  -  20

Maria   - 28

Julio   -  26

Now, the result of name& '|' &age is:

Peter|20

Peter|20

Maria|28

Julio|26

The count distinct of this is 3 (because Peter|20 is repeated twice).

I hope this helps.-

[jagan]

Hi,

This will count the distinct number of concatenated name and age fileds and separated by '|' character.

Hope this helps you.

Regards,

Jagan.