I am receiving the following error when I try to calculate the price field times the quantity field in the same table. the error it: error: no implicit conversion of String into Integer. the price is from another table 's dataset but it populates fine in that field. it is a money datatype. the quantity field is custom list in which I gave the following: 1, 2, 3, 4, 5…I am not sure why I would need to convert a string when neither is a string datatype.
It’s probably interpreting the list data as a string. You can use Ruby’s to_i method to convert the offending field to an integer. For example:
quantity.to_i * price
Thank you for your response. I tried to convert using the method you have suggested. However, I am now getting another error about the formatting. [error: FormattedValue can’t be coerced into Fixnum] Any suggestions on how to remove this error.
Not sure you can see it but here is a link to my dataset: https://www.mockaroo.com/schemas/63868
Looks like the formula you want is:
line_price.to_i * line_quant.to_i