What do you expect it to show? Are you trying to create a line for each item? In that case you need to subtotal by item number and insert the subtotals.

Yes I want it to show for each item. Here is what I have:

2 formulas to pull the 10wk sales and 3wk prev year sales:

IF {@Date Diff} IN 0 TO 69
THEN {SRW68 Transactions.Quantity sold}
ELSE 0
and
IF {@Date Diff} IN 344 TO 365
THEN {SRW68 Transactions.Quantity sold}
ELSE 0
*** I have subtotals on those 2 formulas

from there I took the subtotals and created 2 more formulas:
'10WK - 40PERCENT' (({@10wk}/10)*.4)
'3WK - 60PERCENT' (({@3wk/3)*.6)

From that I did a formula to calculate the Weekly Sales Forecast:
{@10WK - 40PERCENT}+{@3WK - 60PERCENT}

I cannot subtotal this formula (Crystal will not let me do this?)

Maybe I am over-thinking the process to get the answer I need??

You can't subtotal the formula because adding together the percentages is meaningless. You need to recalculate the numbers using the subtotals in the subtotal section.

A suggestion. Get the report generating summary numbers and breaks before you start adding formulas. Can you create a report that just shows the total dollars sales by item over a specific period?