HELP! formula for OBIEE

ariel20029

Board Regular
Joined
Jun 20, 2013
Messages
97
Hi all,
I have tried ( I am very new to this) to write a CASE statement where if the product Family= custom and unit list price =0 return NO
but the tricky part is everything else with a list price of 0 needs to be YES else NO.

No matter how I write the statement the list price of 0 is overriding the product family.



I tried and or..anything I could think of..
any help would be appreciated.

Basically our custom items do not have a list price so I need to keep them in the population and manually update the list price, but anything else that has a list price of 0 return Yes.

Sharon
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

macfuller

Active Member
Joined
Apr 30, 2014
Messages
258
You don't have a lot of information here, but typically for multi-conditions if clauses you would do something along the lines of...

SWITCH(
TRUE(),
[Product Family] = "custom" && [Unit List Price] = 0, "No",
[Unit List Price] = 0, "Yes",
"No"
)
 

ariel20029

Board Regular
Joined
Jun 20, 2013
Messages
97
Hi thank you, I had to modify a little as the syntax was slightly different but this is exactly what I needed... THANK YOU!!!
Sharon
 

Watch MrExcel Video

Forum statistics

Threads
1,090,234
Messages
5,413,226
Members
403,468
Latest member
adenard

This Week's Hot Topics

Top