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! Go to Solution.
Btw, is there a problem adding PI manually inside the expression to calculate the area?
3.14159265...
Is your column a Decimal one? How many decimal digits are allowed?
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
Btw, is there a problem adding PI manually inside the expression to calculate the area?
3.14159265...
User | Count |
---|---|
38 | |
32 | |
30 | |
17 | |
16 |