Strange problem with decimals

[Alfredo_Pou]

I have the following expression:
([Sucursal Id].[Recargo Tarjeta])/100

When dividing by 100 it doesn’t show me the decimal part, so if the value is 15, instead of 0.15 it shows 0.
This has never happened to me before and I assume there is a mistake of mine that I am not seeing. But, the source of the data is of type “Number”, the Virtual column where I use it, was of type “Number” and I also tried with type “Decimal” with 2 decimal digits and it still gives me 0 as a result.
I enclosed with parentheses, to separate the terms well.
What can be the mistake?

[Hocappsheet]

[decimals]/[decimals]=decimals
[Number]/[decimals]=Number

[Lynn · Accepted solution]

Hi @Alfredo_Pou
Check this out

help.appsheet.com

DECIMAL()

Decimal from any value

[LeventK]

Alfredo_Pou:

I have the following expression:
([Sucursal Id].[Recargo Tarjeta])/100

Try with ([Sucursal Id].[Recargo Tarjeta])/100.00

[Steve]

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…