Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I have a column with a rather large script that the end result gives me a a displayed "yes" and "no". I want to count the columns total "yes" and total "no" so i can make a simple percentage display of "yes". Again the script to get the yes and no is rather large so i do not want to include that script in my count if possible. I just want a sum all the yes and no in that one column based on the display of "yes" and "no". Is this possible?
May be just this
Count yes
Count({<FieldName = {'yes'}>} FieldName)
Count no
Count({<FieldName = {'no'}>} FieldName)
It almost works, its only counting one(1) and not summing them all up
Is this field coming from table not joined to your main table?
No its from the main table or actually the only table i have.
Couple of things to check
1) Do you have more than 1 rows in your table?
2) If you do, make sure you DO NOT do DISTINCT Count.... You need a simple count here...
yes there are several rows in the column, and again scripting to get the results of yes and no is lengthy. But basically i have a 100 rows and 75 are given the results (and displayed) "yes" and 25 are "No" I want to have a percentage bar up top that says 75% yes so thats why i am trying to do the count.,
This should work in that case
Count({<FieldName = {'yes'}>} FieldName)/Count(FieldName)