0 Replies Latest reply on Dec 19, 2012 11:26 AM by adriana.mendiola

    General: Match calculation not working properly

    adriana.mendiola

      Hi there,

       

      I'm trying to do a simply match calculation with the below formula:

       

      W/W Coverage Change:

      IF [Week 1 Coverage]=[Week 2 Coverage]

      THEN "Not Changed"

      Else "Changed"

      End

       

      Week 1  and Week 2 Coverage are calcuations:

      Week1 = IIF([Week]="Week1",[Current Coverage - BMC],NULL)

      Week2 = IIF([Week]="Week2",[Current Coverage - BMC],NULL)

       

      These will produce what the customer segment is by report date so example for Accountx, Week1 = Commercial and the same account in Week2 = Commercial.

       

      What I want to show is if Commercial = Commercial for the same account then give me "Not Changed" else give me "Changed."

       

      Currently what I get is "Changed" with the formula above for all accounts no matter if the segment matches in week 1 and week2.

       

      Can someone please help?

       

      Thank you, Adriana