troubleshooting Question

Format a decimal to string

Avatar of cebu1014
cebu1014 asked on
9 Comments3 Solutions2981 ViewsLast Modified:
I didnt develop this code. I want to modify the last line.
The promodsc will be a negative number with decimal value. I want to eliminate the sign and decimal. For example promodsc is -4.99. I want it change to 499. The rest of command will give me 0000000499+ string I need. What do I need to change here?

   REPLACE FRT       WITH RIGHT("0000000000" + ALLTRIM(B->SHIPTOTAL),10) + "+"
   REPLACE DISC_AMT  WITH RIGHT("0000000000" + ALLTRIM(b->promodsc),10) + "+"
Pavel Celba
All in One

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 3 Answers and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros