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.

kohlivinayak's avatar
kohlivinayak
Resolver I
8 years ago
can you share that file back
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

kohlivinayak,

 

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

  • kohlivinayak's avatar
    kohlivinayak
    Resolver I
    8 years ago
    Thanks finaly got it