Cumulative Sales Line Chart
Hi everyone,
I reached out to Quick Base support but unfortunately got the most ridiculous no effort answer ever :(. So disappointed in that honestly as they are normally helpful. I assume checked...
Forum Discussion
I am getting this error:
using this summary formula on a line chart:
var text QUERY = "{56.EX.'XXXX'}AND{101.EX.'XXXX'}AND{278.EX.'XXXX'}AND{299.EX.'0'}AND{351.EX.'XXXX'}AND{352.EX.'XXXX'}AND{85.GTE.'1'}AND{85.LTE.'12'}";
SumValues(GetRecords($QUERY),363)
What am I doing wrong?
Fields 56, 101, 278, 351, and 352 are text fields and the 'XXXX's replace specific text values for filtering. Field 299 is a checkbox field. Field 85 is a numeric field and I want records with values from 1 to 12. The sum field, 363, is a numeric field.
------------------------------
Adam Keever
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendTry tjhis
SumValues(
GetFieldValues(
GetRecords($QUERY),
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
------------------------------
Adam Keever
------------------------------I was using a summary formula when I should have been using a report formula...
------------------------------
Adam Keever
------------------------------well that was unexpected...
------------------------------
Adam Keever
------------------------------