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

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
9 years ago

Hi AlejandroPCar,

 

Would you like to try this? Maybe it could work.

Exportaciones Variacion % =
IF (
    [Exportaciones I] = 0;
    IF ( [Exportaciones II] = 0; BLANK (); -1 );
    IF (
        [Exportaciones II] = 0;
        BLANK ();
        DIVIDE ( [Exportaciones I]; [Exportaciones II]; 0 ) - 1
    )
)

Best Regards!

Dale

  • AlejandroPCar's avatar
    AlejandroPCar
    Helper IV
    9 years ago

    Hi,

     

    Thanks for help me, but it dosent works, the result its the same I had.

    • 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.