6 Replies Latest reply: Feb 13, 2018 1:36 AM by Tresesco B RSS

    How to use variables in expression.

    deb sahoo

      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.