Subtracting a total only in a certain month

[QueSpr04]

CR 10
ODBC[RDO} connection

How can I get a formula to subtract a total from another field only when it is a certain month. That month being October. For instance if a have a total from one formula that is 12,000, and the other field is 1,200, I want 1,200 to be subtracted from 12,000 only in the month of October. Please Help!

 

[bdreed35]

Create a formula that checks the month and only subtracts the other formula if month is 10.

if month({table.date}) = 10 then
    {@formula1} - {@formula2}
else
    {@formula1}

Of course, you need to substitute you fields.
If you want the current month, substitute {table.date} with CurrentDate.

~Brian

 

[synapsevampire]

How was this total created? Do you mean when the month the report is ran is October, or a date field is October?

Posting technical information generally helps:

Crystal version
Database/connectivity used
Example data
Expected output

You were kind enough to post some of this critical information.

One method is to create a formula which will use an IF statement:

If month({table.field}) = 10 then
sum({table.field1})-sum({table.field2})
else
sum({table.field1})

If you're using a Running Total, use the evaluate->Use a formula to allow for this.

If this doesn't get you there, please provide your environment and more descriptive information.

-k

 

[QueSpr04]

Thanks bdreed35. That formula worked perfectly.