I have a straight table with dimensions and expressions and now i need to search by one of them. I have tried to make a listbox with the expression and not getting the desired result in the table. The function "searchable" also doesnt work as desired when i have so many dimensions.
The expression in the table that i want to search by is:
sum(rangeonly(if(CostDate>=IncomeDate_from and CostDate<=(if(isnull(IncomeDate_to), 'vToday', IncomeDate_to)),TotalCost))))
This expression gives a result between 0 and 1, I would like to have a listbox with the alternatives 0-0,2 & 0,2-0,4 & 0,4-0,6 and so on.