Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using below expression in a text box, and it's just giving me blank values:-
=sum({<[YTD-flag]={1},[XYZName]={'$(=$(=vUserXYZ))'}>}[abc_$(vCurrency_Fxx)])
Please suggest, what is causing an error
then [XYZName]={'$(vUserXYZ)'} should be enough i believe. try that .
For simple variables the way you defined it should work $(=$(=vUserXYZ)). i am just wondering if the complexity of the variable and the double $ sign expansion somehow messes things up
How is your variable defined?
i would try and define the variable with abc inside it?
i.e. instead of [abc_$(vCurrency_Fxx)]) just use $(vCurrency_Fxx_dim)
where vCurrency_Fxx_dim is 'abc_' &$(vCurrency_Fxx)
=sum({<[YTD-flag]={1},[XYZName]={'$(=$(=vUserXYZ))'}>}[abc_$(vCurrency_Fxx)])
In above expression, [abc_$(vCurrency_Fxx)], this variable is working fine, if I just do sum([abc_$(vCurrency_Fxx)]), I am getting values.
Issue is with [XYZName]={'$(=$(=vUserXYZ))'}
where vUserXYZ=if(GetSelectedCount([XYZ Name]) = 1,[XYZName],If(IsNull(Only({<[User]={'$(=$(vUser))'}>} Distinct [User APH])), 'Product Hierarchy structure'
,Only({<[User]={'$(=$(vUser))'}>} Distinct [User APH]))
)
do you have an = in from of the expression in vUserXYZ?
Yes, Variable expression is define with an =
then [XYZName]={'$(vUserXYZ)'} should be enough i believe. try that .
For simple variables the way you defined it should work $(=$(=vUserXYZ)). i am just wondering if the complexity of the variable and the double $ sign expansion somehow messes things up
What if I won't use an = sign in variable expression, in that case it should work?
[XYZName]={$(=$(=vUserXYZ))}
But even after using it, not getting proper value.
it should. it does for simpler test i did