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

[#1]

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?

[jagan]

Hi,

Try using [] i.e., [%N]

Regards,

Jagan.

[#3]

Hi,

I tried that as well, doesn't work either :s

[jagan]

Hi,

Can you attach the sample file.

Regards,

jagan.

[jagan]

Hi,

Check whether the variables has values using Text boxes.

Regards,

Jagan.