---
title: "Discussion on \"One Text Amount in getValues() Breaks the Whole Commission Total\" | Hashnode"
description: "Discussion on \"One Text Amount in getValues() Breaks the Whole Commission Total\". getValues() returns text cells as strings, so += concatenates instead of adding. A tested fix that parses amounts to cents and throws on unreadable cells."
url: "https://hashnode.com/posts/one-text-amount-in-getvalues-breaks-the-whole-commission-total/6ad92e206211a13322e8bbba"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [One Text Amount in getValues() Breaks the Whole Commission Total](https://magesheet-team.hashnode.dev/one-text-amount-in-getvalues-breaks-the-whole-commission-total?utm_source=hashnode&utm_medium=feed)

getValues() returns text cells as strings, so += concatenates instead of adding. A tested fix that parses amounts to cents and throws on unreadable cells.

Oct 21 · 5 min read · magesheet-team.hashnode.dev  
Read the article

-   [#magesheet](https://hashnode.com/tag/magesheet)
-   [#google-apps-script](https://hashnode.com/tag/google-apps-script)
-   [#google-sheets](https://hashnode.com/tag/google-sheets)
-   [#javascript](https://hashnode.com/tag/javascript)
-   [#automation](https://hashnode.com/tag/automation)

## Written by

[Hayrullah Kar](https://hashnode.com/@magesheet)

@magesheet · Sakarya,Turkey

  
[View profile](https://hashnode.com/@magesheet)

Founder & Automation Strategist @MageSheet | Google Apps Script & AI Specialist.

Founder &amp; Automation Strategist @MageSheet. I specialize in building intelligent automation systems and custom CRMs using Google Apps Script and AI to eliminate manual workflows and drive business efficiency.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
