Sales Region Value auto-fill

User_YABJ5

Hi!
I am trying to mark all regions except one (Southwest) as inactive (value = 3) automatically using a measure. This measure should look at the Sales region and if it is not "Southwest" it should mark it as 3.I did it manually and it worked but now I need it make it automated. I tried this formula : if(" Sales Region" <> 'Southwest', '3', null). The system tells me that the expression is correct but when I try to open a table with this measure it shows me an error.
I would appreciate any advice on this issue!

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/28437/sales-region-value-auto-fill

Hi @User_YABJ5,

Welcome to the Oracle Analytics & AI Community!

Can you please try a CASE Statement like following to replace the value?

CASE 

    WHEN "Sales Region" <> 'Southwest' THEN '3' 

    ELSE ''

END

Hope this help.

Thank you.