Announcements
Dear Community,
I used below formula to calculate percentage which gives a correct exact value like 11.77884615% . However, it should be 12% i.e. nearest rounded.
Concatenate(((ThisItem.Q2Amount-ThisItem.Q1Amount)/ThisItem.Q1Amount)*100,"%")
created below function but always round to higher integer. It should conditionally show Round down if the value is something like 11.44444%
RoundUp((ThisItem.Q2Amount-ThisItem.Q1Amount)/(ThisItem.Q1Amount)*100,0)
Hi @Vaibhav_kaulkar,
Do you want to round up if the next digit is 5 or higher, otherwise, this function rounds down?
The easiest way is to replace the RoundUp() function with the Round() function.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 360 Super User 2026 Season 2
M Bilal Khan 325
Mohsin Ali 232
