Help

How to multiply comma separated value

722 1
cancel
Showing results for 
Search instead for 
Did you mean: 
loft_Chaman
4 - Data Explorer
4 - Data Explorer

Screenshot_1
Is it possible in airtable?

1 Reply 1
AlliAlosa
10 - Mercury
10 - Mercury

This is possible, but only if you know for a fact that you will only have two values in each set.

Try this:

VALUE(LEFT({Field 1}, FIND(",", {Field 1}) - 1)) * VALUE(LEFT({Field 2}, FIND(",", {Field 2}) - 1)) & "," & VALUE(RIGHT({Field 1}, FIND(",", {Field 1}) + 1)) * VALUE(RIGHT({Field 2}, FIND(",", {Field 2}) + 1))