3 Replies Latest reply on Jan 3, 2020 11:15 AM by Bill Jordan

    Smart Reporting percentages

    Bill Jordan
      Share This:



      I'm trying to create a percentage field by dividing one ticket count by another but I can't get it to return a decimal value from the division, only integers. 


      For instance

      1/4 = 0  instead of .25

      4/1 = 4

      4/3 = 1  instead of 1.33

      3/4 = 0  instead of .75


      It's using the correct numbers for the calculation but the division doesn't return anything but an integer, I've tried every format option I can find.