Virtual column shows two different value while in view mode and edit mode

[Umang_Oswal]

i have one virtual column in which 77/30 = 2.56666666667 which is 2.57

when this virtual column is view in detail view it shows 2 and when same is viewed in edit mode it shows 2.57 (edit mode shows right calculation)

why is this happening?

i have set the virtual colum type as decimal.

[Marc_Dillon · Accepted solution]

Fix for expression giving 0% or missing decimal part Tips & Tricks 💡

Trying to divide two numbers to get a percentage but always getting 0? Trying to divide two numbers but losing the numbers after the decimal point? TRY THIS Convert one or both of the values in your division expression to a Decimal value, either by: (1) wrapping the value in the expression with the DECIMAL() function; (2) multiplying the value in the expression by 1.0; or (3) changing the column’s type to Decimal if suitable to the app. FOR EXAMPLE If computing a percentage from two Number co…