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?
Solved! Go to Solution.
Hi @Alfredo_Pou
Check this out
[decimals]/[decimals]=decimals
[Number]/[decimals]=Number
Hi @Alfredo_Pou
Check this out
Try with ([Sucursal Id].[Recargo Tarjeta])/100.00
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |