Forum Discussion
Solved
divide by Zero ERROR when using DIVIDE()
Hi All, I am working on Student Score Card related dataset and trying to calculate Percentage achieved by Student in each subject. You can see in attachment the MaxMarks is 0 for studid 101 and ...
community_pinki Because you aren't using the third parameter for divide and the default for that is BLANK when you divide by zero. You want:
DIVIDE(SUM(...), SUM(...),0) * 100
community_pinki Because you aren't using the third parameter for divide and the default for that is BLANK when you divide by zero. You want:
DIVIDE(SUM(...), SUM(...),0) * 100