Forum Discussion

kohlivinayak's avatar
kohlivinayak
Resolver I
8 years ago
Solved

zero from divide function showing arbitrary value

Hi all  I am using this below formula    Current PC Contribution = DIVIDE(SUMX(Sheet1,IF(Sheet1[PC - 2]=Sheet1[max pc],Sheet1[Contrib val_3],0)),SUMX(Sheet1,IF(Sheet1[PC - 2]=Sheet1[max pc],Sheet1...
Need Help
Show and Tell
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    kohlivinayak,

     

    Just select the column [Qty in Ton Adjusted] and change the data type as shown below.

v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

kohlivinayak,

 

I can not reproduce the issue. Share us the .pbix file if convenient. Do mask sensitive data before uploading.

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    8 years ago

    kohlivinayak,

     

    The denominator is not exactly zero. A decimal number is always stored as a double-precision floating point value. You may change the data type of [Qty in Ton Adjusted] to fixed decimal number from the Modeling tab.

    • kohlivinayak's avatar
      kohlivinayak
      Resolver I
      8 years ago

      Tried modeling as well as rounding off not working.

      • v-chuncz-msft's avatar
        v-chuncz-msft
        Community Support
        8 years ago

        kohlivinayak,

         

        It works for your .pbix above, please check again. As a kindly reminder, protect your privacy information.