Just to let you know this essential tip:
if you want to do SUM (roll up column) you need to target number format value.
Not IFthenELSE with other IF then else in it or template etc …
So the trick is:
1/create SUM column first by targeting a temporary number column.
2/ create the columns you need, IfthenElse etc…
3/Change the target inside the SUM (rollupcolumn) to your desired column.
But dont touch the dropdown of computing or the name of the column or anything.
Then the rollup column will stay in SUM mode… even if your target is a IF column with sometimes TEXT, or FALSE or empty…
Have a nice day