Number formatter not working

I have a scenario sending Stripe charges to my bookkeeping software. The amount charged comes through to my software without decimal points, so a $30.00 charge gets entered as $3000.

I tried using the number formatter and it seems to be done correctly (see screenshot), but my scenario keeps running into an error “invalid error”

Any insight on what I’m doing wrong?

Screenshot 2023-07-24 205517

Hi @Temima_Gass

The reason for the invalid error is the presence of the dollar sign ($) within the value. To resolve this problem, kindly eliminate the dollar sign before proceeding with formatting.

image

This formula result output 30.00 with $30.00 input.

Thanks $ Regards

MSquare Support
Visit us here
Youtube Channel

2 Likes

Thanks for your reply. I don’t see any dollar sign in the input though. This is what is coming through from Stripe:

Screenshot 2023-07-25 092817