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?