# hiperFormula bug?

**URL:** <https://community.glideapps.com/t/hiperformula-bug/75880>\
**Category:** Ask for Help\
**Created:** [August 26, 2024, 8:47am UTC](https://community.glideapps.com/t/hiperformula-bug/75880 "2024-08-26T08:47:48Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Eliran\_Fadida](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eliran_fadida/32/52440_2.png) [@Eliran\_Fadida](https://community.glideapps.com/u/Eliran_Fadida)\
**Post date:** [August 26, 2024, 8:47am UTC](https://community.glideapps.com/t/hiperformula-bug/75880/1 "2024-08-26T08:47:48Z")

</div>

I’m trying to build a calculator with PMT payments for loans. The column containing the hyper-formula keeps refreshing or sending the UI the number from the previous calculation

 ![Screenshot 2024-08-26 at 11.41.42](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/6/26c8bdb4152060b7ff3c0beb992fb4c5415b65d8.png)

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [August 26, 2024, 6:18pm UTC](https://community.glideapps.com/t/hiperformula-bug/75880/2 "2024-08-26T18:18:54Z")

</div>

Hola!

According to documentation, the **PMT()** function isn’t supported.  
More details here: [Home - Documentation](https://lesterlyu.github.io/fast-formula-parser/)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/0/00098ff2caa0b6c940f07d2023a63623bb9b31ce.png)

Saludos!

---

<div class="post-metadata">

**Author:** ![Eliran\_Fadida](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eliran_fadida/32/52440_2.png) [@Eliran\_Fadida](https://community.glideapps.com/u/Eliran_Fadida)\
**Post date:** [August 26, 2024, 6:33pm UTC](https://community.glideapps.com/t/hiperformula-bug/75880/3 "2024-08-26T18:33:59Z")

</div>

Sometimes it’s work’s… very strange

---

<div class="post-metadata">

**Author:** ![Hassan\_Nadeem](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hassan_nadeem/32/72956_2.png) [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)\
**Post date:** [August 26, 2024, 7:10pm UTC](https://community.glideapps.com/t/hiperformula-bug/75880/4 "2024-08-26T19:10:27Z")

</div>

I would suggest you to use Native Math Column for PMT Calculation.

I have done for a couple of clients and it has been seamless.

You’ll have to breakdown the formula into 2-3 math columns. It’s very simple.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [August 27, 2024, 12:18am UTC](https://community.glideapps.com/t/hiperformula-bug/75880/5 "2024-08-27T00:18:07Z")

</div>

Or an alternative is using a JavaScript function, though you would have to use a template column to pack all 5 fields into a string, then parse them later in JS (because JS column only supports 3 fields).

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [February 23, 2025, 12:18am UTC](https://community.glideapps.com/t/hiperformula-bug/75880/6 "2025-02-23T00:18:17Z")

</div>

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.