I have a rollup field that is pulling the sum of multiple numbers, and in the next field, I want to use that result in a formula, but am getting an error. Before it was a rollup and I just manually entered the number, the formula field worked fine, so I’m assuming it has something to do with changing it to a rollup.

This is my formula, total COG is the result of the rollup field:
IF(COG>0,({Profit}/{Total COG}))

Can rollups not be used in formulas or do I just need to change something about my wording for it to work?

The rollup will work, as long as it results in a number (and in your case, as long as it’s not empty or 0).

Make sure you’re summarizing a number field, and make sure that you haven’t given any opportunities within your Rollup formula for the Rollup to result in anything but a number.

The rollup field is only showing numbers. All other lines where the rollup is only “adding” one value, the formula field is fine. Only the line where the rollup is actually adding multiple values is the formula giving #Error! as the result

Oh my gosh, I completely missed that I didn’t update the first {COG} pull to the new {Total COG} pull, so it was pulling from the wrong column
Now I feel silly, it does work.
Thank you for your help!