Dynamic expression

[Anonymous]

Hi,

I need help with a concept that allow me to input my own amount rather using dimension limits.Importantly, I would very much like to use an INPUT BOX and the RANK FUNCTION eg.IF1000 is specified in the INPUT BOX SUM the totals of all amount greater than 1000.

Thanks

[#2]

Try utilizing inputfields, they can be a part of a table box

[#3 · Accepted solution]

If your input box variable is named vInput, then:

sum({<Amount = {">=$(vInput)"}>}Amount)

[its_anandrjs]

If i am understand the values in your table is

LOAD * Inline

[

Customer,Value

America,1000

Brazil,1500

Russia,1400

];

And create a variable

Let vInputValue = 0; and with the input box enter the values in the variable

Then in expression write like

1. If(Value > $(vInputValue), Sum(Value))

2. And by SET analysis SUM({< Value = { '> $(vInputValue) '}  >} Value)