4 Replies Latest reply on Aug 6, 2015 7:46 AM by Ian Burdin

    Calculated field/logical function

    Ian Burdin

      Hi all

       

      I want to create a calc field whereby I multiply a particular sales channel by a pre-defined cost or price. For example, for the marketing channels as follows:

       

      Paid search - £0.05

      Natural search - £0.00

      Social media - £0.05

      Display - £0.02

       

      All of the above should be multiplied by number of Visits. For instance, paid search had 2,000, social media had 1,000 and so on.

       

      Aggregator - £0.30  this should be multiplied by number or Orders. So for example 500 orders


      Obviously visits and orders are measures that already exist in the workbook. Channel is the dimension I am using for marketing channel


      I have tried an IF and THEN statement for example


      IF (Channel) = "Aggregator" THEN (Orders)*.3

      IF (Channel) = "Paid search" THEN (Visits)*.05

      etc

      etc


      But I am getting error messages...


      Many thanks