Welcome, Guest

How to handle N/A values?
(1 viewing) (1) Guest
 Page:1

## How to handle N/A values? 7 years, 4 months ago #1600

 benjamingraham1934 OFFLINE Fresh Boarder Posts: 4 Karma: 0 Hi Lenny, let's say I want to calculate net tangible assets: Total assets(A) - Cash and equivalents(A) - Intangible assets(A) - Preferred stock(A) - Total liabilities(A) Suppose now that for a specific company the Intangible assets(A) are N/A, then the result of the whole formula is N/A . . . This is very annoying. How to handle this problem? Benjamin

## Re: How to handle N/A values? 7 years, 4 months ago #1601

 admin OFFLINE Administrator Posts: 295 Karma: 17 You can create Advanced Variables with the syntax: CASE WHEN [variable] IS NULL THEN 0 ELSE [variable] END If you recode your variables (which are sometimes n/a) using thet formula, it should function the way that you intend. The following user(s) said Thank You: benjamingraham1934

## Re: How to handle N/A values? 7 years, 4 months ago #1602

 benjamingraham1934 OFFLINE Fresh Boarder Posts: 4 Karma: 0 Can I use this code in a free form column? Could you explain a little bit more? Benjamin

## Re: How to handle N/A values? 7 years, 4 months ago #1603

 admin OFFLINE Administrator Posts: 295 Karma: 17 You first need to go to the Variables menu and click on Create Advanced Variable. You use the code that I provided (and the menu system to insert the code for [variable]). After you name the new variable, you can use that variable in a Free Form Column. The following user(s) said Thank You: benjamingraham1934
 Page:1
Time to create page: 0.09 seconds