3 Replies Latest reply on Aug 16, 2018 8:18 AM by David Matthews

    Calculate % across Row Values

    David Matthews

      Having trouble getting a percentage where it is the sum of the bin columns divided by they Total Open. So its showing % of Total tickets in the bins. Have tried but it comes out empty.SUM([Number of Records]) is what I am using for the Total Open Column. Any suggestions????

       

      SUM([1 - 5] + [6 - 15] + [16 - 30] + [30+])/ SUM([Number of Records])