Set Analysis

[karthikchintu30]

Hi all,

If I have two fields namely student id and weight, weight has values lb's and  kg's and I want to find value of kg's in a separate column for each student id  using set analysis.

[sunny_talwar]

So does the weight includes lbs and kgs or does it say 100 lbs, 50 kgs etc?

[karthikchintu30]

yes it has both

[Somasundaram]

Hi,

along with Aggregate function we can use set analysis,

=count({<weight={'kg's'}>} [student id]) 

[sunny_talwar]

Well what I am trying to understand is the kind of values stored in weight column?

Weight

10

20

30

or

Weight

10 lbs

20 kgs

30 lbs

or

Weight

lbs

kgs

lbs?

[karthikchintu30]

Weight

10lbs

20kgs

30lbs

[Somasundaram]

=count({<weight={"*kgs"}>} [student id])

[sunny_talwar]

In that case try something like this in your set analysis

{<weight = {"*kgs*"}>}

[karthikchintu30]

I want to display the weight value (if I have 10 kgs for student id and then I want the kg's column to be displayed as 10)

[sunny_talwar · Accepted solution]

Use an expression like this may be

Only({<weight = {"*kgs*"}>} Replace(weight, 'kgs', ''))