Report filter to compare two currency fields | Community
Skip to main content
N
NatashaVa
New Participant
January 31, 2025
Question

Report filter to compare two currency fields

  • January 31, 2025
  • 2 replies
  • 353 views

Hello!

I am trying to pull a report that pulls specific criteria including if one currency field is greater than another. What would be the best way to do this? For example, in my screenshot, I know we can't put the field name in the box unless you're in text mode, but I'm trying to show what we are attempting to pull. Does anyone know the best way to write this out in text mode? 

 

 

2 replies

kautuk_sahni
kautuk_sahni
Employee
September 1, 2025

@natashava just checking in! Were you able to get this resolved? If one of the replies above helped—whether it completely solved the issue or simply pointed you in the right direction—marking it as accepted can make it much easier for others with the same question to find a solution. And if you found a different way to fix it, sharing your approach would be a great contribution to the community. Your follow-up not only helps close the loop but also ensures others benefit from your experience. Thanks so much for being part of the conversation!

Kautuk Sahni
KellieGardner
KellieGardner
New Participant
February 3, 2025

I can get it to work with native fields, but it doesn't seem to work with a custom field. Maybe it's how my field was set up that I'm trying to compare (?) but it does appear to work for all native currency fields. 

 

Switch to text mode and put in this for your actual cost fields. Then if you switch back to standard mode the bar will be highlighted, and it becomes a "picker", and you can select other fields to compare. 

 

actualCost=FIELD:budget actualCost_Mod=gt

 

 

    Terms & ConditionsAccessibility statement

    Loading footer...