2 Replies Latest reply on Feb 8, 2016 4:09 PM by Daniel Katz

    Why are my percentages not calculating correctly?

    Daniel Katz

      I am trying to create a calculated field as percentage based upon two measures.  When I do so the number comes out to greater than 100% which is not possible from my figures.  So, to check what is going on I divide one measure by itself.  In this case the math should equal 1 (100%).

       

      The formula is:

       

      IIF([Total] !=0, [Total]/[Total],0)

       

      Yet the total ends up being 124419.1% and then I create another similar calculated field with the same formula and get and 136100.00%

       

      If I simply use [Total]/[Total] I do get the same results.

       

      Any idea for why this simple division operation is not working.