How to sutract revenue from expense in a column

[#1]

Hi All,

I need help creating a formula for one column, so right now my data set looks something  like this

Account, Jan, Feb, Mar

Revenue, 10, 30, 40

Expense, 20, 30, 5

See file attached

How do I create a formula for Net Income?

Can I create a formula for Revenue - Expense and call it Net income

[sunny_talwar]

Look at the attached

[#3]

Hi Sunny,

Thanks for that, but what happens if there's more than one additional formulas now?

For example,  After Net Income,

I apply a .45 Tax Rate

So something like this,

Revenue,

Expense,

Net Income,

Tax

Income After Tax

ROE, etc.

[sunny_talwar · Accepted solution]

You can keep adding more stuff into the Concatenate load here:

Table:

LOAD Level,

     Account,

     Jan,

     Feb,

     Mar

FROM

(ooxml, embedded labels, table is Sheet1);

Concatenate(Table)

Add Only

LOAD * Inline [

Level

Net Income

Tax,

Income After Tax

ROE

];

and use an if statement like you use.

Look here: Cash Flow Statement (with Income Statement & Balance Sheet)

I have not used the link before, but might give you some other ideas

[#5]

Hey, Btw, when I reload, the Net Income disappears.

[sunny_talwar]

Since I did not have the data file, I had to do a partial reload in the script. Change this

Concatenate(Table)

Add Only

LOAD * Inline [

Level

Net Income

];

to this

Concatenate(Table)

LOAD * Inline [

Level

Net Income

];