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

    Smart Reporting percentages

    Bill Jordan
      Share This:

      Hi,

       

      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.

       

       

      Thanks,

      Bill