Skip to Content
0
Former Member
Apr 09, 2014 at 04:10 PM

IF - Else condition is not working properly in Bex Query Designer

224 Views

Hi All,

I have a KF called KPI Value. Based on the KPI Value, my report display has to show by using the if-else condition. If the KPI value is '999999' then that particular KPI value has to display as 'X' against to that KPI No. Thats all my requirement. To achieve this I have created a formula based on the KF.

(KPI Value == 999999)*(1/0)+(KPI Value <> 999999)*(KPI Value)*1

Unfortunately, the above expression is shwoing the entire colmn as 'X' irrespective of the KPI value. i.e., logic is not working 🤪 Could any one please suggest how to achieve this requirement. Your assistance is highly appreciable and very helpful. Thank you in advance!!!

Best Regards

Venkat...