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

AlejandroPCar

 

Can you show us how your data is stored? By sample perhaps?

    

AlejandroPCar's avatar
AlejandroPCar
Helper IV
9 years ago

Hi, I hope it can help.

 

 

 

 

 

 

 

 

  • blopez11's avatar
    blopez11
    Super User
    9 years ago

    Maybe I am oversimplifying, but can you just use the following, and format as a percentage in the Modeling tab?
    Exportaciones Variacion % = DIVIDE ( [Diferencia]; [Exportaciones II] )

    • AlejandroPCar's avatar
      AlejandroPCar
      Helper IV
      9 years ago

      Hi blopez11

       

      I tried it and It works! (partially)

       

      When the result is -100% it will be showed and it is perfect!

       

      But, Im still having this problem:

       

       

       

       

      Thanks a lot!

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        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