topic Re: Set anaylsis expression is not working in App Development

Set anaylsis expression is not working

abc_18 — Fri, 19 Jul 2019 15:52:43 GMT

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

Re: Set anaylsis expression is not working

dplr-rn — Fri, 19 Jul 2019 17:42:19 GMT

How is your variable defined?

Re: Set anaylsis expression is not working

dplr-rn — Fri, 19 Jul 2019 18:00:30 GMT

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)

Re: Set anaylsis expression is not working

abc_18 — Fri, 19 Jul 2019 18:58:30 GMT

=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]))
)

Re: Set anaylsis expression is not working

dplr-rn — Fri, 19 Jul 2019 19:00:35 GMT

do you have an = in from of the expression in vUserXYZ?

Re: Set anaylsis expression is not working

abc_18 — Fri, 19 Jul 2019 19:25:27 GMT

Yes, Variable expression is define with an =

Re: Set anaylsis expression is not working

dplr-rn — Fri, 19 Jul 2019 19:31:18 GMT

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

Re: Set anaylsis expression is not working

abc_18 — Fri, 19 Jul 2019 19:50:21 GMT

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.

Re: Set anaylsis expression is not working

dplr-rn — Fri, 19 Jul 2019 19:52:58 GMT

it should. it does for simpler test i did