Forum Discussion
Solved
Strange % result
Hi All, I am trying to determine why I am getting a certain result with my measures. I cannot make sense of it and am certain I am missing something very basic but for the life of me I can't fig...
Hi,
The denominator is probably not exactly a 0. It could be a very small decimal number. Use the ROUND function in the numerator and denominator to keep only 2 decimal places.
You are dividing by 0 and this functions should work well, try this:
Gross Profit % = DIVIDE ( [Total Gross Profit (USD Fixed)], [Total Sales (USD Fixed)] ,0)
Thanks Allurean, I've tried that previously and same result unfortunately. I think the DIVIDE function defaults to zero if you don't specify that 3rd parameter.