How to use variables in expression.

[debsahoo]

Hello,

Here VSelectedMonth = Month

I have a list box of Month field. The requirement is when I select any month in this list box the variable show that month only and using this variable write a expression to see % of sales in that month of 2010 in a Gauge Chart . I wrote this below expression but its not working please help me out.

=sum({$<Year={"2010"},Month={"=$(=VSelectedMonth)"}>}Sales)/sum({<Year={"2010"}>} Sales)

If I write "=sum({$<Year={"2010"},Month={"Jan"}>}Sales)/sum({<Year={"2010"}>} Sales)" it will work only for January month but I want to use that variable.

Thanks in Advance.

[tresesco]

If you don't include the field in the set analysis, expression would work on - how you select the values from the field. Hence you could try like:

=sum({$<Year={'2010'}>}Sales)/sum({<Year={'2010'}>} Sales)

Or,

=sum({$<Year={'2010'},Month={'$(VSelectedMonth)'}>}Sales)/sum({<Year={'2010'}>} Sales)

[shiveshsingh]

Try this

=sum({$<Year={"2010"},Month={"$(=VSelectedMonth)"}>}Sales)/sum({<Year={"2010"}>} Sales)

[debsahoo]

I try below code it will show 100% for every month.

=sum({$<Year={'2010'},Month={'$(VSelectedMonth)'}>}Sales)/sum({<Year={'2010'}>} Sales)

[tresesco · Accepted solution]

Include Month bifurcation in the denominator like:

=sum({$<Year={'2010'},Month={'$(VSelectedMonth)'}>}Sales)/sum({<Month,Year={'2010'}>} Sales)

[debsahoo]

Thank you Tresesco. It works. But unable to understand the code.

[tresesco]

Learn more about set analysis: Set Analysis: syntaxes, examples