Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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