Conditional Show in Expression based on variable value

[#1]

Hi

I have a list of customers and their total sales value in a table. I also have a slider/input box that allows me to adjust a variable "vSalesValue"

In my table, I would like to be able to see only sales value that falls above the value define in the variable.

I've tried the following expression but it doesn't seem to work:

sum({<sum(Sales_Value) = {'>=$(vSalesValue)'}>} Sales_Value)

Any advice will be appreciated!

[settu_periasamy · Accepted solution]

Hi,

May be try this,

sum({<Sales_Value = {'>=$(=vSalesValue)'}>} Sales_Value)

or

if(Sum(Sales_Value)>=$(vSalesValue),Sum(Sales_Value))

[sunny_talwar]

Try this:

=Sum({<Sales_Value = {"=Sum(Sales_Value) >= $(vSalesValue)"}>} Sales_Value)