Hi All,

How can I apply currency abbreviation for this code block. Currently i used this format below

Field: Formula (Currency)
Summary Type: Sum
Formula:

case 
when 
{type} = 'Bill' and 
{status} in ('Open', 'Pending Approval') 
then 
{fxamount} 
when {type} = 'Purchase Order' and 
{status} in ('Pending Bill', 'Pending Billing/Partially Received', 'Pending Receipt', 'Partially Received') 
then 
{fxamount} 
when {type} = 'Journal' and 
{status} in ('Pending Approval', 'Approved for Posting') 
and ({account} like '%liability%' or {account} like '%Liability%') 
then {fxamount} 
else 0 
end

Custom Label: Amount

sample result that I want

Amount
USD 10,000
IDR 200,000
NTD 15,000

thank you in advance