Stuck on decimal number

RMS
Bronze 3
Bronze 3

My goal is to calculate the area of โ€‹โ€‹a circle, I was stuck with virtual column formula :
DECIMAL(22/7) the result is 3 (far from what I need)
DECIMAL(22) / DECIMAL(7) result is 3.14 (close but i need full decimal)
In Gsheets it is a simple formula just using pi() or 22/7 and the result is 3.14285714285714.
How to get it on appsheet using virtual column ?
Thanks

Solved Solved
0 3 111
1 ACCEPTED SOLUTION

Btw, is there a problem adding PI manually inside the expression to calculate the area?

3.14159265...

View solution in original post

3 REPLIES 3

Is your column a Decimal one? How many decimal digits are allowed?

SkrOYC_0-1664557752599.png

Also, there is a weid bug that sometimes you need to make those 22/7 a 22.0/7.0, so that it's a decimal divided by another one

SkrOYC_1-1664557999078.png

 

Btw, is there a problem adding PI manually inside the expression to calculate the area?

3.14159265...

Steve
Platinum 4
Platinum 4
Top Labels in this Space