Dynamically Calculated Column

ekwo

Hi, I'm trying to add a simple dynamically Calculated Column on a query, but i get this eror
I just want to do something like this : IF BO.ColumnName = 'xxx' then 1 else 0

How do i do this?
Where can I find more about creating calculated columns and what syntax to us in the documentation or in the tutorials?

Evelyn

BLOMASKY

Computed columns are somewhat limited. No problem with simple calculations, but you can't use IF / ELSE logic. If you need that, I suggest you create a computed column in your Business Object and have a rule to compute it whenever the underlying field(s) change.

Bruce

ekwo

Thank you for the reply.
So I can't use case when ... , Replace or Decode?