Decimals >1M not working in PDF workflow attachments

[Simusolar_Surve]

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.

[Steve]

Screenshots of templates, column configs, and/or expressions involved, please.

[Simusolar_Surve]

Here’s how it looks in the app (correct)

[Simusolar_Surve]

Here’s the google doc:

[Simusolar_Surve]

Here’s the result with <10M amount working and >10M amount showing up as a negative:

[Simusolar_Surve]

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:

[Steve]

Why are you converting theses values to Text?

Why not use the raw values in your template?

[Simusolar_Surve]

Here’s one of the actual columns that goes above or below 10M in decimal value:

[Steve]

Please post the type details for the total_price column.

[Simusolar_Surve]

[Steve]

I see nothing that would account for the problem. I suggest you engage support@appsheet.com for a deeper investigation.