Number rounded while should show decimal points

I have a calculated virtual column that shows 2 decimal points in the app. when I prefome an action and send it to G Sheets it rounds the number, although I would like to keep it with the points. in GS the columnis with decimal points.
I tried using decimal() or multiplying by 1.

3X_b_4_b4df283fbf4504e8df5623e2db09028fa6bb2385.png
3X_5_5_551a9b83b577dea4b5750d9bce0b52abe9770ce0.png
3X_6_f_6f779f47572197688ae1b4a914e4017352f3ed07.png

Solved Solved
0 3 165
1 ACCEPTED SOLUTION

Hello @Amitai_Hirshman , is the โ€œParcel Weightโ€ column correctly configured to allow 2 decimal digits just like the virtual column?

View solution in original post

3 REPLIES 3

Hello @Amitai_Hirshman , is the โ€œParcel Weightโ€ column correctly configured to allow 2 decimal digits just like the virtual column?

Multiplying by 1.00 , not a simple 1 ?

You should post and screenshot your formulas/tables configurations

Thanks for the quick answers! found the problem and corrected

Top Labels in this Space