I am trying to update the following query segment in a Sales Analysis cube. I'm not deeply familiar with SQL. 

The first CASE statement works as it should - returns a negative when OINV.Canceled = 'Y'.

```
CASE OINV.Canceled WHEN 'Y' THEN - INV1.LineTotal 
ELSE INV1.LineTotal END AS LineTotal, 
CASE INV1.StockSum WHEN 0 THEN INV1.LineTotal 
ELSE INV1.StockSum END AS SaleValue, INV1.GrssProfit

```

What I'm trying to achieve is for the second CASE statement to also return a negative value (SaleValue) when OINV.Canceled = 'Y'. I think I need to nest a CASE statement here but I'm not sure.