# using IF then WHEN

Member

Hi

I want to add another variable to the above equation but can't get it to work. In my Excel days, I would use an IF statement. Here is my equation:

when 'primary class' = 'supermarkets and grocery stores' THEN sum(case when `Split answer` = 'Female' then `Value` else 0 end) / sum(`Value`)

Thanks

Ben

• Coach

you can use AND to combine logcal expressions together if both should be true or OR if one needs to be true. Alternatively you can add an additional WHEN clause to your case statement to do something diffferent:

```CASE WHEN `primary class` = 'supermarkets and grocery stores' THEN
SUM(CASE WHEN `Split answer` = 'Female' THEN `` ELSE 0 END) / SUM(`Value`)
WHEN `primary class` = 'some other store' THEN
SUM(`some other logic`)
END
```

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

• Coach

you can use AND to combine logcal expressions together if both should be true or OR if one needs to be true. Alternatively you can add an additional WHEN clause to your case statement to do something diffferent:

```CASE WHEN `primary class` = 'supermarkets and grocery stores' THEN
SUM(CASE WHEN `Split answer` = 'Female' THEN `` ELSE 0 END) / SUM(`Value`)
WHEN `primary class` = 'some other store' THEN
SUM(`some other logic`)
END
```