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

# Calculate % across Row Values

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]) • ###### 1. Re: Calculate % across Row Values

Any chance you could share some sample data, even if it's just a mockup?

• ###### 2. Re: Calculate % across Row Values

HI David,

If there is any null may be that's why you are getting blank

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

Hope this helps kindly mark this answer as correct/helpful so that it will help others

BR,

NB

• ###### 3. Re: Calculate % across Row Values

Thanks Naveen

The ZN seemed to be the problem although it seems that using Number of Records didn't work for me. I ended up making a different calc called Open Tickets and then using that instead of Number of Records in the table. So by using ZN and the new Open Tickets it works now.

SUM(ZN([1 - 5]) + ZN([6 - 15]) + ZN([16 - 30]) + ZN([30+]))/ SUM([Open Tickets])