3 Replies Latest reply on May 10, 2018 8:46 AM by NAVYA KARNATI

    SUM IF sentence with 2 conditions

    Giammarco Rizzo

      Hi there.

       

      I am trying to create a Calculated field that is equal to an existing field if 2 conditions are respected, but I always receive "The calculation contains error".

       

      I have inserted the following formula:

      [Customer Count] IF ([Action]="Opt In") AND IF ([Latest Position Ind]="Y")

      Can you please help?