Forum Discussion

AlejandroPCar's avatar
AlejandroPCar
Icon for Helper IV rankHelper 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
Icon for Microsoft Employee rankMicrosoft 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