Strange problem with decimals

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?

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

2 Likes

Hi @Alfredo_Pou
Check this out

3 Likes

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

3 Likes
4 Likes