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
Hola!
According to documentation, the PMT() function isn’t supported.
More details here: Home - Documentation
Saludos!
Sometimes it’s work’s… very strange
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.
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).
1 Like