7 Replies Latest reply on Jun 23, 2016 1:58 PM by Joe Oppelt

    Assigning a numerical value to each row and then using this value in a calculation to create a new measure

    Scott Pantoskey

      Hello,

       

      The title is a bit confusing, but I am trying to assign a decimal value to each row (customer segment) and then use this in a different calculation where I multiply this decimal value by another measure (i.e. sales). This product (i.e. decimal value x sales) will become a new measure.

       

      Can someone please explain the easiest way to go about this?

       

      For example: assigning a decimal value to each customer segment would look like this:

      • IF [customer name] = 'James' THEN 0.15
      • IF [customer name] = 'Bob' THEN 0.15
      • IF [customer name] = 'Frank' THEN 0.20

      Then, I want to take these assigned values and multiply them by the sales for each customer.

       

      This will create a new measure that I want to include in the viz.

       

      Please let me know if you have any questions. Thank you in advance for any help/advice!!!

       

      Thanks,

      Scott