Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Problems with decimals

Hi everyone,   I have a datum in format decimal(19,4) that comes from my database with SQL quering. If I extract it in Power BI, in the data sheets, I obtain it correctly, as shown with 15 decimal...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , You can set number of decimal place in column tools , once click on column in field list

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks amitchandak . 

    The problem is that this setting is visualization...but the data is always different
    I explain it better with an example:

    I made the sum in the red box, and it is quite zero

    ...but not exaclty zero!

     



    So... if I divide the number for this red box, I obtain the green box!

    Because Power BI divides a number for a "quite" zero...and the result is very big!


    If this were exaclty zero...I would have N/ 0 = 0
    instead... I have N / 0,000000000057 = 68937.....