DIVIDE does not show the value

[AlejandroPCar]

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 one value, because in that year that country (Etiopia) didnt import so the value is 0 and even the diference was -3.909,57 the formula DIVIDE does not show the change (-100%) and so on for other countries.

How can I fix that? Make DIVIDE show the value (100% or -100%) for those countries that just have values in one date.  

And I tried replacing in the formula the value BLANK() for 0 but it didnt fix the error because now it show me all the countries even those with both 0 values.

Thanks for read me!

[v-jiascu-msft]

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]

Hi,

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

[Anonymous]

@AlejandroPCar

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

[AlejandroPCar]

Hi, I hope it can help.

[blopez11]

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]

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 · Accepted solution]

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

[AlejandroPCar]

Thank you! Problem solved!

[Anonymous]

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]

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]

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.