Be able to compare two field values under Reporting/Actions/Filter

[#1]

I would like to be able to compare the field values in the Project Report (e.g. Project Territory vs. Company Territory) to avoid mismatch data.

Ideally we shouldn't be creating the same field in Company and Project Level. This is our temporary solution for the other issue. When using the billing report, we can't access the Company level fields, therefore the field has to be recreated in the Project level

[#2]

Coincidentally this is possible to do in the API by using the "FIELD:" prefix. I sure wish it was available in reports too. Good request.

[#3]

If you switch a report to text mode you can replace the equals string with FIELD:name and then when you switch back to standard mode you should be able to select the second field to compare with. Making it easier in standard mode would be great however.

[#4]

Yes, I will give this a shot

[#5]

Thanks Melinda and Eric

[#6]

We would really benefit from this feature! Today we have lots of reports as a work around. we will try the workarounds above but as a non-technical team, having this ability natively would be helpful. We tried the FIELD:name in text mode but cannot get it to work with a custom field.