topic Re: Text apostrophe with formula in variable in App Development

Text apostrophe with formula in variable

Anonymous — Wed, 13 Jun 2018 09:48:30 GMT

Hello,

I have the following problem and I can't find a solution. I have defined the next variable in the variable interface:

vActualMonth

Definition:

'P08'

I have introduced the ' apostrophe symbol because I'm using this variable value in the following formula in order to select this single month in the addition:

Sum({$<Month_Key_PL={$(vActualMonth)}>}Sales)

If I don't introduce this ' in the variable, the addition doesn't work.

Now I want to automate this variable and i have defined it with this formula:

=Pick(1,[Actual Month])

I have the current month P08 selected but without apostrophe ' and the Sum formula doesn't work. I have tried different ways to include this apostrophe:

='''&Pick(1,[Actual Month])&''' --> apostrophe in apostrophe

="'"&Pick(1,[Actual Month])&"'" --> apostrophe in quotations marks

These solutions didn't work.

Someone can help me with this issue? How can include an apostrophe and a formula together?

Thank you so much!

Re: Text apostrophe with formula in variable

sunny_talwar — Wed, 13 Jun 2018 16:01:37 GMT

Not sure, but seems like you are complicating your expression... have you tried this?

Sum({$<Month_Key_PL= p([Actual Month])>}Sales)

If you still want to go the variable route, may be try this

=Chr(39) & Pick(1, [Actual Month]) & Chr(39)

Re: Text apostrophe with formula in variable

Anonymous — Thu, 14 Jun 2018 12:54:25 GMT

I have used a drop down menu linked to this variable and the variable is used in a chart where I can compare and see differences between months. The variable shows the actual month as default but I can change this variable with the drop down menu to do comparisons between the months that I want.

Thank you, Your solution works!

Re: Text apostrophe with formula in variable

sunny_talwar — Thu, 14 Jun 2018 12:57:22 GMT

Super, please close the thread by marking correct response.

Best,

Sunny