Reporting Decimal Places

[Octfolio_Seb]

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!

[LeventK · Accepted solution]

Have you tried with:

<<(COUNT(FILTER(Visited, TRUE))*100.00/COUNT(FILTER(Total, TRUE)))>>

Levent KULACOGLU
ABLE3 Ventures, LLC
Managing Partner

[Octfolio_Seb]

@LeventK you are a superstar, it works! Thank you so much! What a simple solution.

[LeventK]

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.