Simple division decimals values do not appear in result

Get Help
1

Hello,

I am working on a native query. And I'm doing a simple division, the results should be for example 0,9512 but in the table it shows only 0. Although I tried to change the minimum number of decimals, it keeps showing 0. And if for example I try to multiple for 1000, the value also does not change.

image
image1362×701 37.7 KB

Please, can somebody help me?

2

Hi @Laura.dropp
Post "Diagnostic Info" from Admin > Troubleshooting, and the database type you're querying.

3

Thanks for the reply. I'm new in Meta Base, how should I post the "Diagnostic Info"? Is direct in the MetaBase page?

4

@Laura.dropp Here. Copy and paste it here.

5

I did a data type change when i encountered this error. Using the cast function - cast my column to a float and the result showed

1 Like
6

If it makes the SQL simpler, just put 1.0 * in from the calculation.

select z.a/z.b as doesntWork,
1.0 * z.a/z.b as works
from
(select 5 as a ,6 as b) as z

Gives:
image