cancel
Showing results for 
Search instead for 
Did you mean: 

If formula in BO

Former Member
0 Kudos

Post Author: metoo

CA Forum: Formula

I am a user of Business Objects V6.

I have the following table:

Col1 Col2 Col3

x y

x y

x z

I want to create an "if" formula on col3 that evaluates if col2==Z then col3=0 else col3=1. Kind of how the if formula works in excel. Is there a way to do this?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Post Author: Bandit07

CA Forum: Formula

If {table.col2} = 'Z' then 0 Else 1

B