Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a doubt which seems very basic but I am unable to find the solution.
I have a field named 'Product' with values 'CITY', 'Civic', 'Jazz' etc
If I set the expression,
Sum({<Product={'CITY'}>}sum) ... I get the CITY specific chart. But I want to make the chart dynamic based on the 'Product' selection made by the user....
So I have set a variable named 'ProVar' which will have its correspoding 'Product' value assigned as user selects from a product list box.
I need to edit the expression so that it will take the ProVar and change Dynamicaly.
When I modify the expression like this Sum({<Product={ProVar}>}sum) its not working.
I know that it shud be a simple issue.. but it'll be of great help if you can just let me know the correct syntax for framing in the set expression in this case.
sum({<Product=${ProVar}>})
use this may it helps u.
Regards,
Chandra
I tried using Sum({<Product={'$ProVar'}>} sum) .. but still this is not working..
Hi,
sum({<Product=${ProVar}>})
use this may it helps u.
Regards,
Chandra
Sum({<Product={$(ProVar)}>}sum).please try this
Hi,
sum({<Product=$(ProVar)>})
hey sorry for the previous post , i for got to use braces
Regards,
Chandra
Hi,
you have to enter:
Sum({<Product={$(=Only(Product))}>} Fieldname)
or if you want to use a variable, define one at Settings:
varProduct =Product
Sum({<Product={$(varProduct)}>} Fieldname)
hi,
it will be easier to help if you post the definition of your variable ProVar. Depending how this is set will shwo you hwo the varaible shoudl be dealt with.
For a start $ expansion requires that the varaibel to be expanded is found inside the brackets like this $(ProVar).
However thsi may react differently depending on what ProVar contains.
start by replacing
Sum({<Product={'$ProVar'}>} sum)
with
Sum( { <Product= {$(ProVar)}>} sum)
see what happens. If no luck post teh definition of your variable
This worked fine for me
Sum({<'$ProVar'>} sum)
Thanks a lot for your replies