Forum Discussion

Pinky0404's avatar
Pinky0404
Icon for Helper III rankHelper III
8 years ago
Solved

NaN Error

Hi All,   I  have two columns , "Total Queries" & "Other blocked" and when i try to divide Other blocked / Total Queries is throwing NaN value when both columns has value 0. Hence unable to calcula...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Pinky0404,

     

    Glad to hear that you have resolved your problem. Would you please kindly mark your sharing solution as an answer so that it can benefit more users?

     

    Thanks,

    Yuliana Gu

Pinky0404's avatar
Pinky0404
Icon for Helper III rankHelper III
8 years ago

Thanks for your response. I found an answer. i was directly dividing the columns  which was giving  the total % , rather calculating as sum(other blocked)/sum(total queries).

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Pinky0404,

 

Glad to hear that you have resolved your problem. Would you please kindly mark your sharing solution as an answer so that it can benefit more users?

 

Thanks,

Yuliana Gu