Hi
I am building an application based on a large dataset (∼ 100m rows).
In the application there is a main table containing all rows with a calculation condition set to <120.000 rows.
I recently figured out how to work with sliders and variables and have added this to the application. The slider is based on an index of price increases, and the table then shows all rows where the price increase is greater than or equal to the the selected value per the slider.
The expressions in the table are conditionally based on MyIndexField (Column(3)). Meaning that every expression except for the index is set with the same condition: =IF(Column(3)>0, MyField)
And the index field is set with: =IF(MyIndexField>=myVar, MyIndexField)
My problem is that when setting the slider to a specific value, this doesn't fulfill the calculation condition even though it should result in fewer than 120.000 rows.
Does anyone know how to go about this?
Thanks in advance
