http://www.sqlpower.ca/forum/posts/list/206.page JForum - http://www.jforum.net
I created a derived measure for my KPI and the formula is this:

(x-y)/y * 100.

Some rows evaluate to NaN and some to 'oo' (the infinity symbol). Is 'NaN' equal to 'Not a number'?

Just making sure i understand these 'symbols' correctly...

It looks like when i have an expression:
1) '(0-0)/0 * 100', this evaluates to NaN .
2) '(60-0)/0*100', this evaluates to infinity.

I thought anything divided by 0 equals 'infinity' but looks like if the numerator is 0, then the result is NaN on the Dashboard?

Just curious...]]> http://www.sqlpower.ca/forum/posts/preList/2002/3125.page http://www.sqlpower.ca/forum/posts/preList/2002/3125.page GMT
The particular rules that govern what result you get are specified by IEEE 754. They reflect what you'd generally see in a math class these days. 0/0 is indeterminate; (<0)/0 is -infinity; (>0)/0 is infinity; infinity/infinity is indeterminate, and so on.

-Jonathan
]]> http://www.sqlpower.ca/forum/posts/preList/2002/3128.page http://www.sqlpower.ca/forum/posts/preList/2002/3128.page GMT