Forum Discussion

community_pinki's avatar
community_pinki
Helper II
5 years ago
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 104 in Subject English and Math respectively.
When I drag and drop it into Table visual it is showing BLANK. Why So?


Could anyone ellaborate this and How can we replace this blanks with something else or zero.

 

 

Any Help would be Appreciated...


Thanks..

Need Help
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    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

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    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