Business Objects

[GoodDwayne]

I have a report in Business Objetcs and I need to create a formula. The field name is called WO Priority. I need to create a column with the field to give me the meaning of the WO priority.

I need a formula for this. If the WO Priority = 1 then Extreme
If the WO Priority = 3 then Normal
If the WO Priority = 2 then Undecided

 

[GoodDwayne]

So far I have written =If([WO Priority])=3 Then "Normal"

Do I need to add a comma or semi colon to add to the formula. For example:

=If([WO Priority])=3 Then "Normal",=If([WO Priority])=1 Then "Extreme" or

=If([WO Priority])=3 Then "Normal";=If([WO Priority])=1 Then "Extreme

 

[hilfy]

It looks like you're working with a Webi report, not Crystal. This forum is for Crystal Reports. For Webi questions, you should go here:

http://www.tek-tips.com/threadminder.cfm?pid=393

Having said that, here's the formula you're looking for:

=If([WO Priority] = 1; "Extreme"; If([WO Priority] = 2; "Undecided"; "Normal"))

-Dell

DecisionFirst Technologies - Six-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com

 

[GoodDwayne]

Thanks Dell. That is what I needed.