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

Hi Ailsa,

 

Thanks, but a sum of the individual %'s is not what I am looking for here.  I'm looking to understand why 

DIVIDE ( [Total Gross Profit (USD Fixed)], [Total Sales (USD Fixed)], 0) 

 

Is evaluating to a huge percentage on the aggregate/total line....when it seems like 1.24 divided by 0 should be 0.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
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.