Divide or iferror doesnt produce correct result when value has 0

[natabird3]

Dear all,

I have a simple divide measure that should divide one data with another. Both values are derived as measures, which filters two values and then i simply tried using the iferror(actual/budget, blank()). Then I tried with divide instead of /, however in both results i am still getting some strange results:

Any idea why i still get value for when dividing by 0? Should remain blank but it isnt. I also tried if(budget=0, Blank(), IFERROR(actual/budget, blank())) but again was getting those in there. Any ideas would be appreciated, using direct query for this. 

[amitchandak]

@natabird3 , You can use

divide

Divide([actual],[budget])

or

Divide([actual],[budget],0)

[Greg_Deckler]

@natabird3 You should use DIVIDE(actual,budget, blank()) Don't use IFERROR, it is slow.

[natabird3]

Unfortunately, with divide like this i am still getting the large % values which i cannot explain why is happening, instead of those being replaced by blanks. Any ideas?

[Greg_Deckler · Accepted solution]

@natabird3 It's almost certain because it has budget values that are very close to zero, but not really zero, like .0000001 or something. You probably need ROUND.

[natabird3]

indeed using Round helped to solve the issue.