7 Replies Latest reply on Dec 27, 2018 11:49 PM by Deepak Rai

# Replacing Null Values with 'N/A' in a Numeric Field without converting it into string.

Hi,

I want to replace all the Null values in the Percentage column to 'N/A' without converting it to string. I  have calculated percentage using the calculated field with the formula ((New + Old)/New). It returns Null where New is 0. I want to convert all the Null values in the column to N/A without converting it into string as conversion will eliminate % sign and decimal values as well and other numeric properties. Is there a way to do so ? . I have search on the internet and everyone is converting the column in string using IsNull function.

• ###### 1. Re: Replacing Null Values with 'N/A' in a Numeric Field without converting it into string.

You need to use Round with % to convert it to String and then you can Convert Null to N/A.

• ###### 2. Re: Replacing Null Values with 'N/A' in a Numeric Field without converting it into string.

"N/A" is text, so it has to be stored in a string.

You can convert a number to a string and keep the % sign, the decimal places and certain other attributes as well BUT it will still be a string and you won't be able to do other numeric functions (SUM, AVG, etc) with it.

• ###### 3. Re: Replacing Null Values with 'N/A' in a Numeric Field without converting it into string.

thanks

• ###### 4. Re: Replacing Null Values with 'N/A' in a Numeric Field without converting it into string.

Deepak how can i use % with round ? can you elaborate?

• ###### 5. Re: Replacing Null Values with 'N/A' in a Numeric Field without converting it into string.

• ###### 6. Re: Replacing Null Values with 'N/A' in a Numeric Field without converting it into string.

can you please elaborate how can i use round with % ?

• ###### 7. Re: Replacing Null Values with 'N/A' in a Numeric Field without converting it into string.

Here is detailed Explanation:

Thanks

Deepak

If this Helps, Pl mark it Helpful and CORRECT to Close Thread

1 of 1 people found this helpful