SUM( SELECT(invb [vbal], and( [_THISROW].[vendor] = [vendor],[_THISROW].[_RowNumber]>[_RowNumber] ) ) )
this formula took too long
my table have about 6000 rows
and this is not big for my data
any help
Each of those 6000 rows must scan all 6000 rows, which results in (6000 * 6000) = 36000 rows scanned. That’s not trivial. And it’s on top of any other virtual column you have to calculate.
Perhaps find a way to store the computed value in a regular column rather than using a virtual column? Or move the computed column to a table with one row per vendor. The solution depends on what you’re trying to accomplish.
1- how to force table to be sorted by date
2- how to filter the table for 1 vendor that selected from vendor table in order to reduce calculation
In a view? Using the view’s configuration.
slice don’t stop calculation i need to run that calculation when i need for only 1 vendor so it can be easy for the app to handle
User | Count |
---|---|
42 | |
26 | |
25 | |
17 | |
13 |