I saw the earlier list you posted and how you wanted to calculate the sum of desired fields.
How are you managing color code it to “red”? so far with current structure I assume you’re using conditionals. I would suggest create a colorcode field in your datatype and once the field has red color then add the sum in variable to improve data loading.
Let me know if you need more help! and hire me to fix the issue.
Filtered works much slower than a pure ‘do a search’, as all the data has to be loaded out. It may be better to precalculate/store the values you are trying to show into a separate table so that you can do a simple search to pull out the data you need.
The tradeoff is that you have to calculate the change after every new entry.
ya- i think this is the best approach. I was debating on adding the latest data onto “User,” but tried to avoid it b/c “User” dataType gets too many data fields. I think your proposal is still the cleanest approach.