Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Re: Single Select Field and Currency Field Formula Results in Error

Solved
Jump to Solution
1717 0
cancel
Showing results for 
Search instead for 
Did you mean: 
CottageKeeper
6 - Interface Innovator
6 - Interface Innovator

Trying to accomplish this simple formula but it results in an error???
Using a Single Select Field and a Currency Field.

{Toe Kick LI} * {Toe Kick Cost Per LI}
Screen Shot 2023-06-09 at 10.34.20 AM.png

Screen Shot 2023-06-09 at 10.28.22 AM.png

 Thanks in advanced for your assistance!

1 Solution

Accepted Solutions
BillH
9 - Sun
9 - Sun

You need to convert the single select to a numeric value.  I believe (Value(Toe Kick LI)) * (Toe Kick Cost Per LI) should work.

 

See Solution in Thread

3 Replies 3
BillH
9 - Sun
9 - Sun

You need to convert the single select to a numeric value.  I believe (Value(Toe Kick LI)) * (Toe Kick Cost Per LI) should work.

 

Stephen_Orr1
10 - Mercury
10 - Mercury

@BillH is right. Airtable sees single select options as objects containing text in this case and is having trouble inferring that this text should be converted to a number when multiplied/divided (it works fine with + or -). IMO this is a bug (great catch!).

This formula will work:

VALUE({Toe Kick LI}) * {Toe Kick Cost Per LI}

CottageKeeper
6 - Interface Innovator
6 - Interface Innovator

Perfect!  Thank you!