Welcome, Guest

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

TOPIC: How to handle N/A values?

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

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

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