Question

2
Replies
285
Views
Close popover
Arpan Parikh (ArpanP77)
Texas Commission On Environmental Quality

Texas Commission On Environmental Quality
US
ArpanP77 Member since 2018 9 posts
Texas Commission On Environmental Quality
Posted: September 20, 2018
Last activity: September 21, 2018
Closed

Export to Excel - Currency Format (Pega 7.1.8)

Hello,

Hope everybody is doing well. My requirement is to export data to excel. The problem is occuring in exporting currency value where excel just displays decimal values instead of displaying into currency format. i.e Excel displays 2000.00 instead of $2,000. It should export the data it displays on the front-end

I am attaching screenshots for your reference. The amount property is defined as Decimal in pega and formatted as Currency while displaying.

Thanks in advance for your help.

Regards,

Arpan Parikh

***Edited by Moderator Marissa to update platform capability tags****

Data Integration
Moderation Team has archived post