Subtotals in Crystal

[stoopers]

Formulas for summarizing Dollar amounts by specific month cannot be subtotalled. What would be causing this? I am attemptig to create a report which contains the months for 2005 across the top...

Product Sales Jan05 Feb05 Mar05
8263 $100 $100 $100

 

[kskid]

Need more detail information to better visualize the problem you are experiencing.

Crystal Version
sample data
formulas

Where are the formulas located in the report

-LW

 

[stoopers]

I was on the boards yesterday attempting to identify new customers (no orders for the same product in the last 12 months). I was able to get the correct data using the formula below but I only need to summarize the '05 orders by month.

Crystal 7.0
Scala 5.1

2005 AMOUNT = IF ((MINIMUM(LastYearYTD) - MINIMUM({FTSALES_HISTORY.DEL DATE},{@PRODUCT})) <1) AND {@YEAR} <> [2003, 2004]
OR ((MINIMUM(LastYearYTD) - MINIMUM({FTSALES_HISTORY.DEL DATE},{@PRODUCT})) > 365)
THEN {@AMOUNT}

Formula for @amount = quantity * sales price

I then created formulas to sum each month of 2005 individually. I have probably made this more complicated but I am new to both Crystal and Scala. I have groups based upon the customer code and product.

Greatly appreciate any suggestions!!