If formula in BO

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?