Hello Gliders, I am having a weird problem with the rollup column. It is suddenly showing the COUNT option only. The SUM option does not appear. Any clues?
That means the column value you are trying to Rollup is not a number. Trace back through your IF column and any columns that feed it. Does it have the potential to return blanks or text at any point? Are any other columns that it returns actually number or text. Just because it visually looks like a number doesn’t always mean it actually is a number.
That is what I thought at first. However, if in the rollup column (which works fine to begin with) I change the field “summarize the value of” to point to a different field, and then I change it back to what it was before, the SUM option is gone. The images below show the before and after.
Jeff thank you so much! The key phrase was POTENTIAL TO RETURN TEXT. I found an IF THEN that worked with numbers but in the ELSE I had put the word “Error”. That was enough to ruin the rollup. Upon deleting that word the rollup showed SUM again. Thanks!!!
1 Like