Oracle Analytics and AI

Sales Region Value auto-fill

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!

Find more posts tagged with

aggregation

Rules

Demand Management

Accepted answers

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.

All comments

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.

User_FBM2B

Hi,

“Your formula is close, but the issue is that you’re treating the field name and values like strings. In most BI tools (Power BI, Qlik, etc.), you need to reference the column directly, not put it in quotes. Try something like:

IF([Sales Region] <> "Southwest", 3, BLANK())

This way the measure checks the actual column value, not a literal string. Also, use BLANK() instead of null to avoid rendering errors in visuals.