Forum Discussion

AlejandroPCar's avatar
AlejandroPCar
Helper IV
9 years ago
Solved

DIVIDE does not show the value

Hi!     I have these problem.   Im using DIVIDE and these is the result:   First I have two values for Eslovaquia in two dates and the result is right. But in the second, I have only on...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    Hi AlejandroPCar,

     

    Did you mean the blanks? Maybe you could try to add one more parameter to "divide".

    Exportaciones Variacion % =
DIVIDE ( [Diferencia]; [Exportaciones II]; 0 )

    Best Regards!

    Dale

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi AlejandroPCar

 

It's probably because you have blanks instead of zeros in your exportaciones columns. Try to replace blanks with zero in those columns.

AlejandroPCar's avatar
AlejandroPCar
Helper IV
9 years ago

Hi Anonymous

 

Thanks for respond!

 

I dont have blanks in my exportaciones columns. Some years there are some countries and other years could be the same or others contries, but I dont have all countries all the years.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    No problem.

     

    I think you need to add some conditions to your calculations then. If exportaciones is blank, then it's dropped with 100 percent, and don't calculate if exportaciones is blank, because it will yield the result infinity.

     

    You can try to show me your measure and how your data is stored. Then I can help you make the right measure.