2. Whether the pills are empty. It will give this error if you are trying to add an empty pill. This is especially important to check if you are using a pill from a Search, an optional field, or a field nested under a conditional action. In case it could be blank, you can use the .present formula. You can see more information about that here: http://docs.workato.com/formulas/number-formulas.html#present
Let us know if you have further questions!
Answer
Patricia Guevarra
said
over 4 years ago
Hi Saul,
Thanks for reaching out! There are two things you need to take note of:
2. Whether the pills are empty. It will give this error if you are trying to add an empty pill. This is especially important to check if you are using a pill from a Search, an optional field, or a field nested under a conditional action. In case it could be blank, you can use the .present formula. You can see more information about that here: http://docs.workato.com/formulas/number-formulas.html#present
Saul Macht
Error adding two data pills: Error calculating input for field 'message': false can't be coerced into Float
I'm trying to add two amounts in a log message and am receiving this error. What would be causing it?
Hi Saul,
Thanks for reaching out! There are two things you need to take note of:
1. What data format the pills are in. It should be in integer or number format to be added. Take note of the icon beside the data pills, it should appear as 0.00. You can see more information about that here: https://support.workato.com/solution/articles/1000153309-recipe-basics-understanding-app-data-and-field-mapping
If it isn't, you need to convert it using a .to_f or .to_i formula. You can learn more about that here: http://docs.workato.com/formulas/number-formulas.html#conversions
2. Whether the pills are empty. It will give this error if you are trying to add an empty pill. This is especially important to check if you are using a pill from a Search, an optional field, or a field nested under a conditional action. In case it could be blank, you can use the .present formula. You can see more information about that here: http://docs.workato.com/formulas/number-formulas.html#present
Let us know if you have further questions!
Patricia Guevarra
Hi Saul,
Thanks for reaching out! There are two things you need to take note of:
1. What data format the pills are in. It should be in integer or number format to be added. Take note of the icon beside the data pills, it should appear as 0.00. You can see more information about that here: https://support.workato.com/solution/articles/1000153309-recipe-basics-understanding-app-data-and-field-mapping
If it isn't, you need to convert it using a .to_f or .to_i formula. You can learn more about that here: http://docs.workato.com/formulas/number-formulas.html#conversions
2. Whether the pills are empty. It will give this error if you are trying to add an empty pill. This is especially important to check if you are using a pill from a Search, an optional field, or a field nested under a conditional action. In case it could be blank, you can use the .present formula. You can see more information about that here: http://docs.workato.com/formulas/number-formulas.html#present
Let us know if you have further questions!