My formula took too long and app don't work

AppSheet AppSheet Q&A
1

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

1 Like
2

zarif_Melika:

my table have about 6000 rows

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.

2 Likes
3

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

1 Like
4

zarif_Melika:

how to force table to be sorted by date

In a view? Using the view’s configuration.

zarif_Melika:

how to filter the table for 1 vendor that selected from vendor table in order to reduce calculation

5

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