Solved
Query giving values of zero
What's wrong with this query format. I have checked all the values and I should be getting values other than zero. SumValues(GetRecords("{80.EX.'"&[Concate Distance]&"'}and{47.EX.'Shipping'}and {66....
The API has good performance. You could try the same query in the API and see if you get the results you need then use AI to create a basic code page for that API query.
See here:
https://developer.quickbase.com/operation/runQuery
You can just fill in the blanks and it will basically make the API query for you under code sample tab. Recommend to use Javascript ES6.
