ON ADD COLUMN: DIVIDE() function with two columns yields wrong result?

[pcowman]

Hi,

I've looked into the queries on the boards but don't see a solution for my specific problem.

I have two fields which I need to divide. I have created sum measures for these fields but the divide function is still giving me an incorrect result. I tried changing it to Field/Field and still I get the same result. I saw in someone else's post that changing to measures corrected the row level problem but it isn't for me. It did get rid of infinity results and the result showing as 100,200 or more.

Estimated GM% = DIVIDE([Sum Planned]-[Sum Est Cost],[Sum Planned],0)

[jthomson · Accepted solution]

That Estimated GM% column in your visual (the one on the right without the space) looks to be giving the correct results based on your DAX, it's just not formatted as a percentage?

[pcowman]

Crap you're right. Thanks. I did that several times and kept coming up with 85% not 92. just did it again and came out with 92. *bangs head*