Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
change NaN value to another value
Migrateduser
Hi,
I want to create a computed column in a data set, which is the ratio of 2 output columns
I wrote an expression to change possible NaN result due to division by 0, but I still have NaN as a result.
Here is my expression :
value = new Number(row["C1"]/(row["C2"])*100);
if(value == Number.NaN)
{
value = 100;
}
value;
Any solution ?
Find more posts tagged with
Comments
There are no comments yet