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?

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.

Can I use this code in a free form column?

Could you explain a little bit more?

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.