How to get rid of "infinity" ?

[netanel]

Hi All!

I have this sample Measure:

Gross Budget Diff% = [Gross USD AVG] / [Gross Sum January] -1

And I can not get rid of the text "Infinity"
Instead of getting 0

Anyone know this?

Please help

Thanks!

[Samarth_18]

Hi @netanel ,

Try this:-

Gross Budget Diff% = Divide([Gross USD AVG], [Gross Sum January],0) -1

Thanks,

Samarth

[netanel]

@Samarth_18 

i get - 100% insted

[Samarth_18 · Accepted solution]

@netanel This is because of -1 at the end. So do you need it? if not you can remove it or if you need it then you can try below code:-

Gross Budget Diff% = 
var result = Divide([Gross USD AVG], [Gross Sum January],0)
return if(result=0,0,result - 1)