Forum Discussion

dusdau's avatar
dusdau
Icon for Helper II rankHelper II
4 years ago
Solved

Strange % result

Hi All,   I am trying to determine why I am getting a certain result with my measures.  I cannot make sense of it and am certain I am missing something very basic but for the life of me I can't fig...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    The denominator is probably not exactly a 0.  It could be a very small decimal number.  Use the ROUND function in the numerator and denominator to keep only 2 decimal places.

dusdau's avatar
dusdau
Icon for Helper II rankHelper II
4 years ago

Wow, it was so small i could not see the decimal place even when expanding the decimals out.  Putting a ROUND on it confirmed this...and I feel like an idiot now. 🙂  Thanks for the help.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

You are welcome.