Text Mode Help Please | Community
Skip to main content
J
JaneBr
Level 4
October 21, 2020
Solved

Text Mode Help Please

  • October 21, 2020
  • 1 reply
  • 649 views

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?

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by JaneBr

    Thanks Sarah that worked. I just tweaked it slightly:

    billingRecordID_Mod=notblank

    projectID=FIELD:billingRecord:projectID

    projectID_Mod=ne

    1 reply

    S
    SarahNa
    Level 6
    November 2, 2020

    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!

    J
    JaneBrAuthorAccepted solution
    Level 4
    November 6, 2020

    Thanks Sarah that worked. I just tweaked it slightly:

    billingRecordID_Mod=notblank

    projectID=FIELD:billingRecord:projectID

    projectID_Mod=ne

      Terms & ConditionsAccessibility statement

      Loading footer...