Re: Determining net profit for month.

Posted by Brian Cummings on August 25, 2004 at 14:11:45:

In Reply to: Re: Determining net profit for month. posted by Sue Sloan on August 25, 2004 at 10:48:55:

: To get the total cost you would need to first add a calculated field to get the cost for each order item, then a summary of that field:

: LineItemCost = ordetail.UnitsOrdered * products.COST
: Sum_LineItemCost = SSum(LIneItemCost)

: Add the fields to the report in question's summary panel(s).

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.

Thanks again for your help,
Brian

Follow Ups:

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

Post a Followup

Name    : 
E-Mail  : 
Subject : 

Comments:
: : To get the total cost you would need to first add a calculated field to get the cost for each order item, then a summary of that field:

: : LineItemCost = ordetail.UnitsOrdered * products.COST
: : Sum_LineItemCost = SSum(LIneItemCost)

: : Add the fields to the report in question's summary panel(s).

: 
: 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.

: Thanks again for your help,
: Brian


Optional Link URL:  
Link Title:         
Optional Image URL: