Text Mode Help Please

[JaneBr]

I am trying to create a report to show where the field 'Hour Project ID' differs from the field 'Hour Billing Record Project ID' in a Billing Record on a Project. This is because we have noticed some tasks are being moved from one project to another even though the billing record has a status of Billed.

So, in summary, I need some text mode to enable me to view where the data in an Hour Project ID field does not match the data in an Hour Billing Record Project ID field. Can anyone help me please?

[SarahNa]

Hi Jane,

We don't use billing records so I don't have a good environment to test in, but could an hour report with this filter work?

projectID=FIELD:billingRecordID

projectID_Mod=cine

Good luck!

[JaneBr · Accepted solution]

Thanks Sarah that worked. I just tweaked it slightly:

billingRecordID_Mod=notblank

projectID=FIELD:billingRecord:projectID

projectID_Mod=ne