Airtable has been very useful to me because of their ability to perform Excel-like functions. For example this monthly payment formula can be done by reference other fields in a record:
{Loan Amount}*({Monthly Rate}*POWER(1 + {Monthly Rate}, INT(Amortization)*12))
/ (POWER(1+{Monthly Rate},(INT(Amortization)*12))-1)
From what I can tell, Xano allows for basic math, ie addition/subtraction, but not the above?
How would I go about replacing these formulas so I can migrate out of Airtable and into Xano.
Thanks!