Forum Discussion

katlyncowley's avatar
katlyncowley
Qrew Assistant Captain
6 years ago

Report Formulas

I'm looking to create a report formula for a report. We use this report to follow up on support tickets. For example, a Priority 1 call should be repaired in under 3 hours, so I need the report to show only calls that have not been created or modified within the last 3 hours, that way we can call the location or technician.

I know how to do this on a daily basis using report filters, but I really need this 3 hour mark so that I can send the list out to my employees.

------------------------------
Katlyn Allen
------------------------------
Formulas and functions
reports and charts
  • AustinK's avatar
    AustinK
    Qrew Commander
    6 years ago
    Create the report formula and once it is created it will be at the bottom of your field list in the regular report filters and you can then use it there. You just need to filter it based on your formula checkbox being equal to 1.

    You want to go with a formula checkbox and filter your report based on this being checked to show those records. I am fairly sure this formula would work for you but let me know how it goes. It will show them once the duration of hours between the submission or the date modified is over 3. Hopefully I understood your request but let me know if I did not.

    if(
    toHours(Now() - [Date Created]) > 3 or toHours(Now() - [Date Modified]) > 3, True, False
    )
    • katlyncowley's avatar
      katlyncowley
      Qrew Assistant Captain
      6 years ago
      Formula error
      The field is text but the formula returns a bool result.

      Otherwise, I think this is exactly what I was looking for. 

      ------------------------------
      Katlyn Allen
      ------------------------------
      • AustinK's avatar
        AustinK
        Qrew Commander
        6 years ago
        It sounds like the report formula was just left on the default of Formula - Text and a change to Formula - Checkbox should fix that for you.

        It should not have any errors other than that assuming you are using the exact fields in my formula, Date Created and Date Modified.