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

    Calculation field for components in a measure

    Haan Haan


      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?