Reporting Decimal Places

expressions
reports
(Sebastian Tiller) #1

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!

(Levent Kulacoglu) #2

Have you tried with:

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

Levent KULACOGLU
ABLE3 Ventures, LLC
Managing Partner

2 Likes
(Sebastian Tiller) #3

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

(Levent Kulacoglu) #4

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.

1 Like