Formula is not working when calculating with other column values

Hi, I have created a formula column that I want to divide the values in two other columns. But when I add the percentage option, the formula does not calculate the values correctly.

Hi Jenna,

Could you possible share the formulas here with a screenshot?

Hi@jennabeaudry ,
the formula you are using to divide the values in two columns and calculate the percentage is probably incorrect. The correct formula should be:

If you are still having trouble getting the formula to work correctly.
Try using a different formula, such as the AVERAGE() function, to calculate the percentage.

For further implementation details kindly connect us:
MSquare Support
Visit us here
Youtube Channel