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 :

      Capture.JPG

      So far so good

       

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

       

      Capture2.JPG

       

      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?