topic Re: Variables in Set Analysis, Left side of = in App Development

Variables in Set Analysis, Left side of =

WiscoSippi — Mon, 20 Aug 2018 16:14:14 GMT

Hello!

I'm trying to use a variable on the LEFT side of my SA equation. The measure is calculating as if there isn't any set analysis.

Any suggestions?

Here's the measure with the variable in red

=sum({< $(vMeasureSelection_542_RA_Account_Group) = {'Revenue'} >} $(vMeasureSelection_RA_542_Actuals) )

That variable contains a pick function and two field names as options:

pick($(vMeasureType), RA_Actuals_Group, Act_Group)

Any thoughts?

Re: Variables in Set Analysis, Left side of =

lblumenfeld — Tue, 21 Aug 2018 03:54:54 GMT

Have you tried this?

Sum(

If(Pick($(vMeasureType), RA_Actuals_Group, Act_Group) = 'Revenue',

Pick($(vMeasureType), RA_Actuals_Group, Act_Group),

)

What can vMeasureType be? If it is a string, instead of a number, then you might need to enclose $(vMeasureType in single quotes. '$(vMeasureType)'

Re: Variables in Set Analysis, Left side of =

pradosh_thakur — Tue, 21 Aug 2018 05:24:15 GMT

=sum({< [$(vMeasureSelection_542_RA_Account_Group)] = {'Revenue'} >} $(vMeasureSelection_RA_542_Actuals) )

variable

try using an equal sign before

=pick('$(vMeasureType)', RA_Actuals_Group, Act_Group)

=pick($(vMeasureType), RA_Actuals_Group, Act_Group)

Re: Variables in Set Analysis, Left side of =

jonathandienst — Tue, 21 Aug 2018 05:49:44 GMT

You can use a variable on the LHS as long as it expands into a valid field name. put =vMeasureSelection_542_RA_Account_Group

into a text box. Does it display the field name?

Is vMeasureType as numeric?

Define vMeasureSelection_542_RA_Account_Group with a leading = sign as suggested above.

Re: Variables in Set Analysis, Left side of =

WiscoSippi — Tue, 21 Aug 2018 14:36:49 GMT

Hello! I figured out how to get it to work. All of the suggestions provided were very helpful but the final solution was slightly different. See below for the working versions. Original pieces are in red and the additional code is in blue:

sum( {< $(=$(vMeasureSelection_542_RA_Account_Group)) = {'Revenue'} >} $(=$(vMeasureSelection_RA_542_Actuals)))

Also had to modify the variable $(vMeasureSelection_542_RA_Account_Group), again additions are in blue:

pick( $(vMeasureType),'[RA_Actuals_Group]','[Act_Group]')

Re: Variables in Set Analysis, Left side of =

WiscoSippi — Tue, 21 Aug 2018 14:37:46 GMT

Thank you!! I figured it out. Slightly different than what you proposed. I replied to the original post with the correct info.

Re: Variables in Set Analysis, Left side of =

WiscoSippi — Tue, 21 Aug 2018 14:37:53 GMT

Thank you!! I figured it out. Slightly different than what you proposed. I replied to the original post with the correct info.

Re: Variables in Set Analysis, Left side of =

WiscoSippi — Tue, 21 Aug 2018 14:38:08 GMT

Thank you!! I figured it out. Slightly different than what you proposed. I replied to the original post with the correct info.