Query Formula

[Former Member]

hi,

I have a requirement in the query:

IF ((<b>X</b> Price – <b>Y</b> Price) / <b>Y</b> Price) > 10% = 1 ELSE = 0

( I mean if >10% of the Formula the result value should show 1, Less than 10% value should show 0)

Please let me know if you have any thoughts in the BEx algorithms. I appreciate your feedback.

[Former Member]

Hi Mkk,

Create a CKF and just write the following formula.

((X Price – Y Price)*100 / Y Price) & uncheck on calculation after aggregation.

then create new CKF1 and just write the following formula.

(CKF > 10)*1

Anuj Chaudhary

[jaya_mogali]

Hi Mkk,

You can use boolean operators available.

Create a CKF and just write the following formula.

(((X Price – Y Price)*100 / Y Price) > 10)

Jaya

[Former Member]

Hi,

Thanks for the quick update. I tried it before posting but it didn't work out. I need if it is > 10% = 1 ELSE 0

I couldn't find any formula in boolean operator.