Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have data as below
country Population income
a 100 10
b 200 20
c 300 30
d 400 40
i need drop down list box, in which i want population or income as field values
i need another drop down list box which should contain >,<,>=,<= as values
i need a input box where i can give input values as numbers
my selection will be as below
my output will be
straight table
Create two Variables.
Symbol and Value
SUM({<country = {"=Sum(Population)$(Symbol)$(Value)"}>}Population)
If you want to load Symbol as Inline table and use them as List box Selection... add below in your script..
Load * Inline
[
Symbol
<
<=
>
>=
];
Now use expression as below.
SUM({<country = {"=Sum(Population)$(=GetFieldSelections(Symbol))$(Value)"}>}Population)
Hi,
some similar solution might be:
Only({$<country={"=$(=vField&vOperator&vValue)"}>} $(vField))
see also:
The Magic of Dollar Expansions
hope this helps
regards
Marco