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.