My formula needs to add another field once a calculation has occured. This formula creates the total impressions. Sometimes there is no line item value but we just want to add impressions which is what the field "Append Impressions" is for.

The formula below is my attempt to say:

If Entertainment is chosen, use CPM version 1 then add the field Append Impressions to that CPM total.

The formula works fine when there is value in either Line Item Value field or Product-CPM field. But it does not return just the Append Impressions value when the other two fields are 0 - which is what I need it to do.

If(

[RFP/IO - Brand Category]="Entertainment",

(([Line Item Value]*1000)/[Product - Minimum CPM ENT]) + [Append Impressions],

(([Line Item Value]*1000)/[Product - Minimum CPM]) + [Append Impressions])

The formula below is my attempt to say:

If Entertainment is chosen, use CPM version 1 then add the field Append Impressions to that CPM total.

The formula works fine when there is value in either Line Item Value field or Product-CPM field. But it does not return just the Append Impressions value when the other two fields are 0 - which is what I need it to do.

If(

[RFP/IO - Brand Category]="Entertainment",

(([Line Item Value]*1000)/[Product - Minimum CPM ENT]) + [Append Impressions],

(([Line Item Value]*1000)/[Product - Minimum CPM]) + [Append Impressions])