Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Use an expression like this may be
Only({<weight = {"*kgs*"}>} Replace(weight, 'kgs', ''))
So does the weight includes lbs and kgs or does it say 100 lbs, 50 kgs etc?
yes it has both
Hi,
along with Aggregate function we can use set analysis,
=count({<weight={'kg's'}>} [student id])
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?
Weight
10lbs
20kgs
30lbs
=count({<weight={"*kgs"}>} [student id])
In that case try something like this in your set analysis
{<weight = {"*kgs*"}>}
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)
Use an expression like this may be
Only({<weight = {"*kgs*"}>} Replace(weight, 'kgs', ''))