https://community.qlik.com/t5/QlikView/Text-Object/m-p/1675886#M592213 <P>you are getting a count. so it will never be 100% unless the count value is 1</P><P>you should change your code to</P><P>count(Online condition)/count(totalnumber) with your number formatting</P> Fri, 14 Feb 2020 18:34:07 GMT dplr-rn 2020-02-14T18:34:07Z https://community.qlik.com/t5/QlikView/Text-Object/m-p/1675882#M592212 <P>I am creating a text object using the following code '=Num(Count(if(State = 'ONLINE'and ID ='s',1.0)),'#.##%')', it is showing me 2800.00% and I am trying to get it o be 100.00% when all the fields show ONLINE.</P> Fri, 14 Feb 2020 18:17:08 GMT https://community.qlik.com/t5/QlikView/Text-Object/m-p/1675882#M592212 tsoley9262 2020-02-14T18:17:08Z https://community.qlik.com/t5/QlikView/Text-Object/m-p/1675886#M592213 <P>you are getting a count. so it will never be 100% unless the count value is 1</P><P>you should change your code to</P><P>count(Online condition)/count(totalnumber) with your number formatting</P> Fri, 14 Feb 2020 18:34:07 GMT https://community.qlik.com/t5/QlikView/Text-Object/m-p/1675886#M592213 dplr-rn 2020-02-14T18:34:07Z