Forum Discussion

dusdau's avatar
dusdau
Helper 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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi dusdau 

You can create a calculated column to count the percentage instead of measure .

Column = [Total Gross Profit (USD Fixed)]/[Total Sales (USD Fixed)]

The result is as shown :

Best Regard

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • dusdau's avatar
    dusdau
    Helper 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
      Super 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
        Helper 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.