Text Object

[tsoley9262]

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.

[dplr-rn · Accepted solution]

you are getting a count. so it will never be 100% unless the count value is 1

you should change your code to

count(Online condition)/count(totalnumber) with your number formatting