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