Advance Saved Search

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

Rookie Asked on November 18, 2021 in Saved Searches.
Add Comment
1 Answer(s)
Best answer

Hi,

Try to edit the formula as follow:

Field: Formula (Text)
Summary Type: Max
Formula:


MAX({currency.symbol}) || ' '|| SUM(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)

 

Matteo

Rookie Answered on November 18, 2021.

wow, it works. thank you so much for your reply

on November 24, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor