In my app, I have a marketplace where one user accepts payment from another user through Stripe.
I want to save the amount the the Payee receives, so that he/she can look up that amount and also view the total amount they have collected. I created Amount Paid as a field in a data type - and have it save as a Number. However, when I use the dynamic data to take the “Amount Charged” from the Stripe workflow, it does not include decimal places, and shows $399.00 as 39900.
I have tried having the “Amount Charged” field save formatted as currency or with decimal places, however, I get a message saying this conflicts with the field type I have set for the field (number), and it should be text. However, if I do that will I not be able to sum the number and get total amounts?