I have two decimal numbers that can range from 100,000 to 22,000,000 for now. They seem to get correctly stored in the database, but when I run a webhook from that table row to generate a PDF, the amounts don’t appear. If I reduce the same amounts to <10M, they appear. There is no space limitation on the PDF, and it’s not a formatting issue because there is a A-B type calculation in the PDF which also breaks when one number exceeds 10M.
Screenshots of templates, column configs, and/or expressions involved, please.
Here’s how it looks in the app (correct)
Here’s the google doc:
Here’s the result with <10M amount working and >10M amount showing up as a negative:
I have tried several other examples, if both amounts are less than 10M then both show up
Here are the columns in the app definition:
Why are you converting theses values to Text?
Why not use the raw values in your template?
Here’s one of the actual columns that goes above or below 10M in decimal value:
Please post the type details for the total_price column.
I see nothing that would account for the problem. I suggest you engage support@appsheet.com for a deeper investigation.
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |