I’m working with a virtual column whose type is “Number” and have been having trouble getting decimals to calculate properly.
If I use “1/3” in an expression the result of the calculation is “0”.
If, however, I type the expression as “1/3.00”, which should produce the same result, I get “0.33”.
Can anyone tell me what is going on?
I want “0.33,” so I’m happy with the result now, but I wonder if I have to type something like “1/3.00” to get the calculation to work properly or if there’s some other issue of which I’m not aware. Also, Is this issue unique to virtual columns?