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.