Re: How do you sum a column of data
Accepted Solutions
[Can’t] formulas act on one column at a time?
Formulas are run once per row. During that runtime, they have access to values in other columns of that row, but they have no idea what data other rows have.
It’s technically possible to put a row reference inside of another row… that’s what a linked record fields is, as well as the fields that make use of linked records. Guessing those won’t help in this case, but they might in others.
[Can] summary bar data [be referenced in] formulas?
Unfortunately no. But the summary bar can combine row data. It also works for grouped data (portions of a column). For example, grouping by month:
If you need to do more complex math (that breaks all of these rules) the scripting block runs JavaScript. But you may want to hire a developer for that if you’re not familiar. Best of luck.
[Can’t] formulas act on one column at a time?
Formulas are run once per row. During that runtime, they have access to values in other columns of that row, but they have no idea what data other rows have.
It’s technically possible to put a row reference inside of another row… that’s what a linked record fields is, as well as the fields that make use of linked records. Guessing those won’t help in this case, but they might in others.
[Can] summary bar data [be referenced in] formulas?
Unfortunately no. But the summary bar can combine row data. It also works for grouped data (portions of a column). For example, grouping by month:
If you need to do more complex math (that breaks all of these rules) the scripting block runs JavaScript. But you may want to hire a developer for that if you’re not familiar. Best of luck.
