Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi,
May be try this,
sum({<Sales_Value = {'>=$(=vSalesValue)'}>} Sales_Value)
or
if(Sum(Sales_Value)>=$(vSalesValue),Sum(Sales_Value))
Hi,
May be try this,
sum({<Sales_Value = {'>=$(=vSalesValue)'}>} Sales_Value)
or
if(Sum(Sales_Value)>=$(vSalesValue),Sum(Sales_Value))
Try this:
=Sum({<Sales_Value = {"=Sum(Sales_Value) >= $(vSalesValue)"}>} Sales_Value)