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.

    Uzair Rasheed Khawaja



      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.