Help with a conditional formula

Topic Labels: Formulas
Solved
218 2
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

Can anyone tell me where I'm going wrong with this formula?

SWITCH( {HS-LA %},
"15%", ({GBP Amount}-{HS-LA Commission}),
"10%", ({GBP Amount}-{HS-LA Commission}-{HS-LA Commission}),
)

Or suggest another way to achieve it - I've tried a few IF options too but can't get that to work either.

For context, I'm a literary agent and depending on the type of deal I do I either take 15% or 10% commission. Where I take 10% a co-agent will have also taken 10% but that's not necessary for me to track, other than that when I'm working out the author's overall income I need to make sure I know they didn't get it (hence trying to take away my commission twice in those instances here).

The closest I got to it working (ie, it actually ran something instead of refusing to save because of an error), I got words back instead of numbers and what I need is numbers.

1 Solution

Accepted Solutions
18 - Pluto

Try removing the trailing comma in your formula:

``````SWITCH(
{HS-LA %},
"15%", ({GBP Amount}-{HS-LA Commission}),
"10%", ({GBP Amount}-{HS-LA Commission}-{HS-LA Commission})
)``````

2 Replies 2
18 - Pluto

Try removing the trailing comma in your formula:

``````SWITCH(
{HS-LA %},
"15%", ({GBP Amount}-{HS-LA Commission}),
"10%", ({GBP Amount}-{HS-LA Commission}-{HS-LA Commission})
)``````

5 - Automation Enthusiast

Ah! Thank you!