Formula for flat fee plus percentage?

skeen503979

Hi there.

I'm trying to create a column that displays a platform fee for sales to specific buyers.  One buyer is a flat percentage of revenue (8%) plus a specific dollar ($20) amount while another buyer is just a flat percentage (6%). 

What would the correct formula look like? 

JosephSerpis

Hi @skeen503979 try this syntax also ensure your Data type is a numeric type like a double as the formula defaults to V_WString.

IF [Buyer Name] = "Buyer 1" then (0.8 * [Revenue]) +20 Elseif [Buyer Name] = "Buyer 2" then (0.6) * [Revenue] Else 0 Endif