Age calculation - formating numbers - rounding

Support
1

Hi there,

here is a simple question : I used the right formula to calculate the age from a birthday date.
The result, although a integer, is rounded.
In other words, if the result is 52,946, it becomes 53 while it should be 52 until you reach your birthday anniversary…

Thank you

2

Hi,

You may use ROUNDDOWN() to tune your calculated result:

圖片
圖片1386×100 7.98 KB

3

Thank you Angie. Is there a URL where I could find the language used in Ragic? with examples? Thanks again

4

Hi,

Are you referring to UI languages? Ragic currently supports English, Chinese (Traditional and Simplified), Japanese, and Spanish. If you would like other custom UI translations, please refer to this document.

5

Hi Angie, just a related question about age calculation : is it possible to use two formulæ in the same cell or field? like in this case (1) age calculation + (2) Rounddown?
Or is it necessary to hide the calculation cell?

Thanks again

6

Hi,

Sure, applying formulas like ROUNDDOWN((TODAYTZ()-A1)/365.25,0) to a numeric field could work.

7

Thanks Angie, I will give it a try!

8

It works fine!
Thanks again

9

@Angie What about if I want to take as an answer age: 40 years & 5 Months .
How we can achieve that? Thanks in advance

10

Hi,

You’ll need 4 fields in total.

A1: Birthday field

A2: “Years” numeric field to calculate the years

ROUNDDOWN((TODAYTZ()-A1)/365.25,0)

A3: “Months” numeric field to calculate the months

ROUND(((TODAYTZ()-A1)/365.25-A2)*365.25/30,0)

A4: “Answer” free text field to combine values with string formulas

A2+" Years & "+A3+" Months"