Re: Determining net profit for month.

Posted by Sue Sloan on August 25, 2004 at 15:42:17:

In Reply to: Re: Determining net profit for month. posted by Brian Cummings on August 25, 2004 at 14:11:45:

: Thanks, Sue. The creation of all the fields and adding them to the report went pretty well for me. This last field "Sum_LineItemCost = SSum(LIneItemCost)" creates totals for the cost of product. How do I create a field that subtracts this cost from the total sales without shipping and tax? I'm looking for a net profit figure here.

: I tried:
: SSum(OrderSubTotal - LineItemCost)
: and
: SSum(Auto_Sum_of_OrderSubTotal - LineItemCost)
: but these created totals greater than the product sales.

: I haven't tinkered much with altering ODP. I don't quite yet understand fully what I'm doing.

You already have the totals you need, so you do not need another SSum() function. Just a simple subtraction like this for a new calc field named Profit:

Profit = Auto_Sum_of_OrderSubTotal - Sum_LineItemCost

Sue Sloan

Follow Ups:

• Re: Determining net profit for month. Brian Cummings 8/25/4 (0)

Post a Followup

Name    : 
E-Mail  : 
Subject : 

Comments:
: : Thanks, Sue. The creation of all the fields and adding them to the report went pretty well for me. This last field "Sum_LineItemCost = SSum(LIneItemCost)" creates totals for the cost of product. How do I create a field that subtracts this cost from the total sales without shipping and tax? I'm looking for a net profit figure here.

: : I tried: 
: : SSum(OrderSubTotal - LineItemCost)
: : and 
: : SSum(Auto_Sum_of_OrderSubTotal - LineItemCost)
: : but these created totals greater than the product sales.

: : I haven't tinkered much with altering ODP. I don't quite yet understand fully what I'm doing.

: You already have the totals you need, so you do not need another SSum() function. Just a simple subtraction like this for a new calc field named Profit:

: Profit = Auto_Sum_of_OrderSubTotal - Sum_LineItemCost

: Sue Sloan


Optional Link URL:  
Link Title:         
Optional Image URL: