How to write a formula using Boolean Operators?

[Former Member]

Dear BW mates,

I have two Key Figures <b>stock</b> and <b>Prevous 12 week Stock</b>.

I want to calculate <b>Excee stock</b> from these with the following condition.

If <b>Prevous 12 week Stock</b>is less than <b>stock</b>then substract <b>Prevous 12 week Stock</b>from the <b>stock</b>. Thease substracted value is the <b>Excee stock</b>.

Please can one suggest me how to use boolean operaters to get this in formula.

Thanks,

SB

[Former Member]

Hi,

Try this:

(<b>Prevous 12 week Stock</b> < <b>stock</b>) * <b>Stock</b> - (<b>Prevous 12 week Stock</b> < <b>stock</b>)* <b>Prevous 12 week Stock</b>

Best regards,

Eugene