trying to run a simple query on memorized transactions, but I keep getting 'invalid expression' on the third line.

Try it in a dataset in suite analytics, it has a formula checker for you that tells you what is wrong.

Thanks, I'll check it out

Maybe try TO_NUMBER({amount}) * TO_NUMBER({quantitiyremaining})