3 Replies Latest reply on Nov 17, 2011 8:48 AM by Andy Cotgreave

    How to Created a Conditional Calculated Field?

    Zyz Iwi

      For Example, I have a field called "Cost Per Install" and it is already a calculated field.

      The problem is how can i create a conditional calculated field base on "Cost Per Install", if I wish this field only show US female.

      I tried to use IF, but it shows "Cannot mix aggregate and non-aggregate comparisons or results in 'IF' expressions."

       

      Thanks a lot!