actually, this is not a bug in eCart.
in this post:
the calculation has 2 single quotes at the end. copying and pasting the calculation from that post works as it should.
in your post in message 5:
the calculation you posted substitutes a single double quote instead of the 2 single quotes.
a single double quote is bad syntax and causes the problem.