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

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

225 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...