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 · Accepted solution]

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

[echuong1]

I agree with the syntax of the solution above, but that formula would give you 80% +20 and 60% respectively. 

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

Essentially, the formula is saying if the Buyer Name is Buyer 1, then use 8% of revenue + 20. If the Buyer Name is Buyer 2, then use 6% of revenue. If the Buyer Name is not Buyer 1 or Buyer 2 (essentially your catchall for the rest of the records), use 0.

Also, ensure you change the data type at the bottom of the formula to a numeric field type like Double. The default is a string (text) value.