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.