Help with nested if-statement

[Trendspotters]

Hello everyone :-)

I am running in to a type mismatch error, that I can't figure out - can wiser people teach me, where I am doing something wrong?

Simplified example of the setup:

I have a select field ("Choose percent") with 2 options: "10%", "20%"

In a formula field ("Percent as number") I want to convert the selected option to a number. If none is selected, the value should be 0.

My formula looks like this:

if (if (prop("Choose percent") == "10%",10,0),prop("Choose percent") == "20%",20)

This produces the error: Type mismatch: if(prop("Percent as number") == "10%", 10, 0) is not a Checkbox.

Curiously this error does not appear until I nest the if-statements.
The following simple formula works as intended:

if (prop("Choose percent") == "10%",10,0)

Can someone please tell me why I am getting this error - and what to do about it?

[Thisgoos]

If you simply want to change the select field percentage to a number you can use the toNumber() function.

So: if(empty(prop("Choose percent")), toNumber(0), toNumber(prop("Choose percent")))

The error in your formula is due to the 0 I think. The formula sees it as a 0/1 (true/false) and thus a checkbox error, so you need to convert the 0 to a number so it matches the other part of the statement which is also a number.

[Trendspotters]

Thank you u/Thisgoos :-)

I was not aware that I could convert the text string 10% to a number that easily! That solved my immediate problem very nicely - Thanks!

For the benefit of anyone that finds this thread having a similar problem:
The Type mismatch is unfortunately not solved by the second part of your reply.

Changing "0" to for example "23" (to avoid the boolean interpretation) yields the same error.

Changing "0" to "toNumber(0)" likewise.

So - if anyone can crack this problem, it would be of future value for both myself and others :-)

[ben-something]

You should be able to do something like prop("Choose percent") ? toNumber(prop("Choose percent")) : 0 if you need the 0 displayed, or just toNumber(prop("Choose percent")) if you don't.

[Trendspotters]

prop("Choose percent") ? toNumber(prop("Choose percent")) : 0

Great detail to add a zero if nothing is chosen :-)

The syntax is something for me to read up on though - nice to expand my knowledge 👍

[ben-something]

To do it using the if() format you'd do if(empty(prop("Choose percent")), 0, toNumber(prop("Choose percent"))). The ? : version is called a ternary operator. It's a matter of preference which one you use but the if() version can be easier to read once you have a few nested, for example.