# How to make a Positive value a Negative value

Member

Sounds like ABS can make a Negative value a Positive value, but how can I do the opposite?

Need the result from this Beast Mode to be converted to a negative value:

```SUM
(CASE
WHEN DATE(`BatchTimestamp`) = DATE('2023-11-22')
AND YEAR(`Month`)=2024
AND `FinancialCategoryName` LIKE '%CAPEX%'
AND `Portfolio 2024_p`='Rejected'
THEN (`PlannedCost`)
ELSE 0
END)
```

Possible?

Thanks!

• Coach

```SUM
(CASE
WHEN DATE(`BatchTimestamp`) = DATE('2023-11-22')
AND YEAR(`Month`)=2024
AND `FinancialCategoryName` LIKE '%CAPEX%'
AND `Portfolio 2024_p`='Rejected'
THEN (`PlannedCost`)*-1
ELSE 0
END)
```

**Did this solve your problem? Accept it as a solution!**

• Coach

```SUM
(CASE
WHEN DATE(`BatchTimestamp`) = DATE('2023-11-22')
AND YEAR(`Month`)=2024
AND `FinancialCategoryName` LIKE '%CAPEX%'
AND `Portfolio 2024_p`='Rejected'
THEN (`PlannedCost`)*-1
ELSE 0
END)
```

**Did this solve your problem? Accept it as a solution!**
• Member

Ah, as simple as that, and I was looking for a function to do it! :)

Thanks!

• Contributor

1. You can use a nested case statement:
2. `SUM`
3. `(CASE `
4. `WHEN DATE(`BatchTimestamp`) = DATE('2023-11-22') `
5. `AND YEAR(`Month`)=2024 `
6. `AND `FinancialCategoryName` LIKE '%CAPEX%' `
7. `AND `Portfolio 2024_p`='Rejected' `
8. `THEN `
9. `(case when `
10. ``PlannedCost` >=0 then `Planned Cost` * -1`
11. `else `Planned Cost` end`
12. `)`
13. `ELSE 0`
14. `END)`

• Member
edited September 10

Hi all,

Follow up to this. I took a before and after of my card to ensure it was accurately converting the positive numbers to negative numbers, and in most cases, it worked as intended. However, for certain Beast Modes, it is invoking the 0 instead of converting the number to a negative. Here is one example:

```MAX(CASE
WHEN `Portfolio 2024_p`='Unplanned'
AND (`First Year of Impact_p` = '2024' OR `First Year of Impact_p` IS NULL)
THEN `Yearly Total RUN Costs (CHF)_p`*-1
ELSE 0
END)
```

As soon as I added the *-1 it changed the result from 850,000 to 0. Why is the ELSE 0 being invoked?

Thanks