Ask Search:
Milis Dua PenerimaMilis Dua Penerima 

adding converted amount in report filter

Is it possible to add Amount (converted) into report filter?

User-added image
Rakesh GuptaRakesh Gupta
- User-added image



Please drag and drop Amount(Converted field) on report, please take a look of snapshot.

Please mark it best answer, if yur query is resolved.

Regards,
Rakesh
Johan YuJohan Yu
Hi Rakesh, I am not looking the converted amount data in report, but as filter. See my screenshot in my question. Thanks.
Rakesh GuptaRakesh Gupta
Hi Johan,

i don't think so it possible.

But i have an idea, why not you can create a formula field based on amount* convrsion rate ...but problem is conversion rate.....(need to find some way)...Give me some time 

Please mark it best answer, if yur query is resolved.

Regards,
Rakesh
Subramanyam MeareSubramanyam Meare
@ Johan,Can you try bucketing that field & add a filter criteria with the bucketed field.
Johan YuJohan Yu
Subbu, I see Amount (converted) is not shown in bucket field as well 

User-added image
Daniel HolmesDaniel Holmes
I have been trying to do this also but not found a solution.

Can I ask if you got your question resolved? I can not believe that you cant do this in SFDC...!?

Thanks
Asish SharaffAsish Sharaff
Hi Johan,

Try the below filter:

use original currency as filter and add currency code. Example: USD 300, SGD 500, JPY 10,000 and etc.

It worked for me. Let me know does this resolve your report issue.
Asish SharaffAsish Sharaff
Hey Mates,

Is the work around working for you all.

Thanks
Asish
Johan YuJohan Yu
@Subbu, Converted Currency fields cannot be used in Bucket Filters
https://success.salesforce.com/ideaView?id=08730000000gieiAAA


Johan YuJohan Yu
Asish, we cannot use converted currency as filter in report.
http://simplysfdc.blogspot.com/2013/01/salesforce-converted-currency-in-report.html
Asish SharaffAsish Sharaff
Hi Johan,

I am aware that we cannot add Amount (converted) as report filter. But it can be a work around to add converted currency code in filter to get the report on Amount (Converted).

Thanks
Asish

Johan YuJohan Yu
Asish, yes you are right.
I have added into my blog earlier
Solution: use original currency as filter and add currency code. Example: USD 300, SGD 500, JPY 10,000 and etc.
Mudasar KayaniMudasar Kayani
Hi,

I am having this issue but dont quite understand the fix, can you provide some more information about this on how to fix.
H PH P
In the filter, simply use the field that is allowed (i.e. Amount) and just put the 3 letters designating the desired currency you want to use in front of the value. For example: "USD 3000"  and not just "3000".