#### Gevans0666

Thread Starter

- Joined
- Sep 6, 2018

- Messages
- 41

- Financial Review
- Future Wave
- In Progress
- Locked-In
- Cancelled

For the following formula - I want anything that has a status of

**Financial Review**or

**Locked In**to run a formula for a dollar value result -- otherwise, I want a zero. Right now I get a

*FALSE*response.

I spread out formula below for easier reading. Here is the Formula I have now - which works except for the FALSE where I want a value of zero:

IF([@[Effective - Adjusted]]="0","0",

IF([@Status]="Locked-In",SUM([@[Reforecast OPEX-SAV]]/[@[Effective - Adjusted]]*[@[Effective Current Fiscal]],0),

IF([@Status]="Financial Review",SUM([@[Reforecast OPEX-SAV]]/[@[Effective - Adjusted]]*[@[Effective Current Fiscal]],0))))