I’m building an expense splitter, so I have some users in a table, and some expenses in another.
I perform some calculations to split the expenses the way I want in the expenses sheet, so I have several ‘Math’ columns there. Then, in the users sheet, I did a relation between them and the expenses, and now I’m trying to sum it all with a Rollup column, to see the ‘total’ someone is owing. The problem here is that there are some ‘Math’ columns that I can sum normally, but some that I can’t. It’s only showing ‘Count’ and ‘Count Unique’ as an option. I guess it’s being recognized as a String, but I don’t know why.