Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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])
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])
I figured it was something minuscule. Just could find it. Thanks so much Sunny!