Income Statement

[jorge15]

I am trying to create an Income Statement by using this fields:

 

-Field 1: Expense Type (Payroll, Operating, Marketing,..)
-Field 2: Expense Amount
-Field 3: ?

 

I need to know how to create totals for each expense type using the field 'expense amount' and need to be able to add and subtract the totals between expense types.

 

Example: Suppose I have multiple sales, Field 1: California,Texas, and Florida; Field 2: Revenue amounts. And I will need to be able to subtract/add sales only from Texas & California. How do I create a field to allow me to do this?

[David Jondreau]

It's not entirely clear from your question, but it appears you're using fields to carry burdens that records should carry.

 

You should have three records. One for each state for those revenue amounts. Once that's in place, then we can talk about how to extract sales using reports and filters.

[comment]

Example: Suppose I have multiple sales, Field 1: California,Texas, and Florida; Field 2: Revenue amounts. And I will need to be able to subtract/add sales only from Texas & California. How do I create a field to allow me to do this?

 

In this example, you would start by finding records where Field 1 is "California" or "Texas". Then you would use Field 3, defined as summary field, Total of [Field 2], to show the total. This is not the only way, but it is the most straightforward one.

 

That said, I am not sure what you mean by "subtract/add". A summary field defined as Total will add all the amounts of the field being summarized; if you have amounts that need to subtracted, they need to be negative.