3 Replies Latest reply on Nov 8, 2018 8:09 AM by Deepak Rai

    IF THEN Statement Question

    Adam Brizuela

      Hi All,

       

      Have an issue trying to resolve. 

       

      Have a data set with a dimension Named: Mono/Color it has a rows identified as such.   I have a calculated field I created named Raw CPP. 

       

      I want to add a specific amount to the rows that have Mono, I want to add .003 to the Raw CPP rate. So (Raw CPP + .003), the Rows that have Color I want to Add .009, (RawCPP+.009).  I want a new calculated field that will have the new CPP rate that has the .003 or .009 added to the Raw CPP.

       

      I just can't get the IF THEN statement right.

       

      Please help.

       

      Thanks,

       

      Adam