4 Replies Latest reply: Feb 16, 2012 9:52 AM by jagan mohan rao appala RSS

    reading var from input box and showing another in a chart according selection

      Hi, I have an input box with predefined dropdown and assign the chosen option to my variable vCountry1.


      Now I have a chart that looks at that value and shows the sold quantities for that selected country in a chart, per quarter, this formula works :


      So far so good


      Now I want to do it different and show another variable as result




      That doesnt work


      The value %N is the calculation of 2 fields : [Sales Quantity S Tonne]/[Sales Quantity Tonne]


      When I use that variable $(%N) in different tables it always works, I don't understand.


      I tried everything : %N, $(%N), =$(%N), =%N, same result: nada.



      What do I do wrong?