troubleshooting Question

Format to the Currency Field

Avatar of n_srikanth4
n_srikanth4Flag for India asked on
DB2SSRSCOBOL
4 Comments1 Solution1760 ViewsLast Modified:
Hi Experts,

 Requirement is simple.  Format the decimal field to the Currency Field  as mentioned in the example below and then convert to varchar.

(example: $20,000.00)

DB2 value of A_LMT : decimal
SSRS report value of A_LMT : varchar


SQL Conditions:

CASE
     when ID_SYS_MTCHD like 'ACM%' AND DS_TAG_ISS_FEE = 'Limit does not match' then CAST(A_LMT AS varchar(14))  
   else 'N/A'
END as ACMValue

Please correct my code above  to required format and please help me with the solution.

Regards,

Sreekanth.
ASKER CERTIFIED SOLUTION
Member_2_276102

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

Join our community to see this answer!
Unlock 1 Answer and 4 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 1 Answer and 4 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