Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Include Month bifurcation in the denominator like:
=sum({$<Year={'2010'},Month={'$(VSelectedMonth)'}>}Sales)/sum({<Month,Year={'2010'}>} Sales)
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)
Try this
=sum({$<Year={"2010"},Month={"$(=VSelectedMonth)"}>}Sales)/sum({<Year={"2010"}>} Sales)
I try below code it will show 100% for every month.
=sum({$<Year={'2010'},Month={'$(VSelectedMonth)'}>}Sales)/sum({<Year={'2010'}>} Sales)
Include Month bifurcation in the denominator like:
=sum({$<Year={'2010'},Month={'$(VSelectedMonth)'}>}Sales)/sum({<Month,Year={'2010'}>} Sales)
Thank you Tresesco. It works. But unable to understand the code.
Learn more about set analysis: Set Analysis: syntaxes, examples