Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have following variables:
vref1=If(GetPossibleCount(p1_ref)=1,p1_ref)
vP1val=If(GetPossibleCount(p1_value)=1,p1_value)
vref2=If(GetPossibleCount(p2_ref)=1,p2_ref)
vP2val=If(GetPossibleCount(p2_value)=1,p2_value)
output of these variables for one case:
vref1= ca_1
vP1val= not configured
vref2= ca_xa
vP2val= 2A
These variables are used in calculated dimension of straight table:
=aggr(Only({$<$(vref1)={$(vP1val)},$(vref2)={$(vP2val)}>} m_field),m_field)
But I am getting blank table for these selections because there is space in "not configured"
When I change vP1val = configured then table is populated with values.
Let me know how to handle this i.e. when there is space in variable value and used in expression.
Kindly help!
Thanks
Add single quotes around your variable in set analysis
=Aggr(Only({$<$(vref1) = {'$(vP1val)'}, $(vref2) = {'$(vP2val)'}>} m_field), m_field)
Add single quotes around your variable in set analysis
=Aggr(Only({$<$(vref1) = {'$(vP1val)'}, $(vref2) = {'$(vP2val)'}>} m_field), m_field)
Thanks! That was quick
Can you let me know what does single quotes indicate?
that you have a literal between two single quotes