Calculated Field

Version 1

    I'm new to Tableau and trying to create a calculated field that has 3 steps of calculations. Looking for help in creating calculated field.

     

    Step :1

    IF [Complexity] = High THEN L1

    IF [Complexity] = Medium THEN L2

    IF [Complexity] = Low THEN L3

     

    STEP:2

     

    L1 = [Complexity]* 2

    L2 = [Complexity] * 1

    L3 = [Complexity} * 0.5

     

    STEP:3

     

    Total = (COUNTD(Builds) *L1) + (COUNTD(Builds) *L2) + (COUNTD(Builds) *L3)

     

     

     

    How do I perform the above calculations using Calculated Fields??

     

     

    Thanks,

    Anoosha