2 Replies Latest reply on Jul 12, 2018 8:48 PM by Haan Haan

    Calculation field for components in a measure

    Haan Haan

      Hi

      What is the calculation field if I want the component in Branch for Paris, France to multiply -1 and for England, US to multiply 1

      I know partial of the calculation only...

       

      IF [Branch]=" France" OR [Branch]="Paris" THEN [Sales] *-1 END

       

      IF [Branch]="England" OR [Branch]="US" THEN [Sales] *1 END

       

      May I know how to make it in 1 calculation field?

      Thanks.