I am building a report which is using data from two separate tables to give me a percentage a project is complete. Iโve got the expression working, e.g.
<<(COUNT(FILTER(Visited, TRUE))*100/COUNT(FILTER(Total, TRUE)))>>
however, it is always giving me a whole number. Is it possible to enforce say 2 decimal places in a report template expression?
Thanks in advance for any suggestions!
Solved! Go to Solution.
Have you tried with:
<<(COUNT(FILTER(Visited, TRUE))*100.00/COUNT(FILTER(Total, TRUE)))>>
Levent KULACOGLU
ABLE3 Ventures, LLC
Managing Partner
Have you tried with:
<<(COUNT(FILTER(Visited, TRUE))*100.00/COUNT(FILTER(Total, TRUE)))>>
Levent KULACOGLU
ABLE3 Ventures, LLC
Managing Partner
@LeventK you are a superstar, it works! Thank you so much! What a simple solution.
Youโre welcome @Octfolio_Seb, my pleasure. Can you please mark my reply as โsolutionโ provided it fits your needs and requirements so that members can search posts for solved tag and benefit from it. Thanks.
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |