Sum a column

I want to sum a column(users specific). I have a store where students buy meal prep items. When they consume “meals” they obtain some energy points that will be represented in a progress/energy bar. Thought it would be a simple. matter. When I attempt a rollup there is only the count option. What would be the best approach?

Make sure the column you’re rollup is a number column. If it’s not a number column already (maybe you’re using an If Then Else) then you can have a math column and point to that ITE column, then rollup using the math column.

1 Like

Details: I have a list of purchased items. A template column checks: “is used” is true and “is a meal” is true. The result is true true. There is a number column with the “meal energy value”. I have ITE column that then displays the “meal energy value” when the template is true true. So for now, my data is stuck in a ITE column. To do the lookup sum back in the user profile table I need the ITE result in a number column. How to do that? I made a math column as you suggested however back in the user profile table the lookup only gives the count option (no sum option is shown.

You can try Valuex1 and point the Value text to your ITE col.

1 Like

Thank Thin! I found what I was doing wrong. I had made the relationship using something other than the users email. Once I did that the rollup allowed for sum

1 Like

If you wanna “filter” a sum in a column by Rollup, you have to do a Relation by a unique value it’ll have in each row, eg. in your case could be the email or another value you have to recognize who it is.

Finally, with this Relation, you can use a Rollup to sum only the values related by that value you made the Relation


10-4. That was my mistake, not using a unique value for the relation. Thanks!


Thank you Lucas, very nice.

1 Like

You’re welcome @Todd_Lichtenwalter!

1 Like

That solved it. Thank you, not only did I not have the relation setup correctly, it required your move of doing a value X 1. :grinning:

1 Like