Issue on Case mapping

[#1]

I have a field on my report that I want to return like this...Here is my SQL code If I were to do it in SQL. How can I return the same thing on my report in Crystal Syntax?

SUM(CASE WHEN {EstimatedItems.IsChange}=0 and {EstimatedItems.BudgetDeleted}<>1 THEN isnull ({EstimatedItems.BudgetPretax},0) + isnull({EstimatedItems.BudgetJCTAX},0) ELSE 0

[DellSC]

I would handle it this way:

1. In the Formula Editor, turn on "Default Values for Null" which will automatically give you 0 as the default if the number is null. This handles the IsNull() part of your formula.

2. Create the following formula:

If {EstimatedItems.IsChange}=0 and {EstimatedItems.BudgetDeleted}<>1 THEN 
  {EstimatedItems.BudgetPretax} + {EstimatedItems.BudgetJCTAX}
ELSE 0

3. In your report, create a summary of this formula.

-Dell