AnsweredAssumed Answered

Calculated Attributes - if-then-else logic

Question asked by Scott Derderian on Aug 30, 2012
Latest reply on Nov 22, 2012 by Dave
Has anyone found a way to incorporate if-then-else logic in populating the value of a calculated attribute?

For example, let's suppose we have 4 fields.

Field1, Field2, Field3, Field4

The calculated field for the sum is straight-forward enough sum(Field1, Field2, Field3, Field4)

However, if I have a requirement psedo-coded as follows:

if (field2=5 or field3 = 5)
then the value of the calculated field is to be 35
else the value of the calcuated field is sum(Field1, Field2, Field3, Field4)

Any and all ideas and input is welcome.