Report filter to compare two currency fields

[NatashaVa]

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? 

[KellieGardner]

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

[kautuk_sahni]

@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!