Total percentage in Table help

[joshrussin]

Hey everyone,

I am trying to get the percentage of goods issued. The count is correct, but when I try to get the percentage, it is missing 0.7 percent. In the excel spreadsheet there is a row of "#N/A" that accounts for the 0.07 percent. How do I get rid of this? Attached is the excel and qlikview file.

[sunny_talwar · Accepted solution]

You had an extra underscore in your set analysis field name Goods Issue Status... try this

Count({<[Goods Issue Status]={'Completed','Not Started'}>}[Goods Issue Status]) / Count({<[Goods Issue Status]={'Completed','Not Started'}>}Total [Goods Issue Status])

[joshrussin]

I figured it was something minuscule. Just could find it. Thanks so much Sunny!