Compare Currency fields

[MatLudlam]

Hi, I have several currency fields on an opportunity and want to ensure that they are all the same. Rather than do this at run time (where things are not always enforced) I want to have a daily report that lists the ones that are issues, and then fix them.

So on my filter for the report I want to compare 2 fields e.g.:

amountCurrency != supportCurrency

I can compare a field to a constant, but I don't seem to be able to compare 2 fields in the report. Can you advise please?

Thanks.

[tanya]

hello,
Report does not support comparing fields, but only if you create other field for this

https://forum.espocrm.com/forum/general/34663-report-filter-for-comparing-values-of-2-float-fields

[MatLudlam]

Ok, thanks. I am on the hosted solution so don't have access to the files.

I will use it as the basis for a solution then; I will create a new, read only field called something like "CurrencyMatches" and update that using a formula on every right. My report can then search for that field being TRUE or FALSE.

Thanks for the help, really appreciated.