Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If your input box variable is named vInput, then:
sum({<Amount = {">=$(vInput)"}>}Amount)
Try utilizing inputfields, they can be a part of a table box
If your input box variable is named vInput, then:
sum({<Amount = {">=$(vInput)"}>}Amount)
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)