Problems using "the value in the field" to filter reports using a duration or summary total field

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • Answered
I'm trying to create a filter that would return records where the value in one summary total field (duration) is not equal to the value in a field that is a duration formula, but it will not allow me to select "the value in the field" in the filter.
Photo of Jennifer Peterson

Jennifer Peterson

  • 448 Points 250 badge 2x thumb

Posted 10 months ago

  • 0
  • 1

I get the same issue. It may be a bug as I don't see anything in the documentation stating that this is a limitation for duration fields. I suggest you open a support ticket to find out.

If they share with you why it's behaving this way please post it here.


If its a bug and you don't have months to wait or a fix, you can make a new field to convert the Duration field to say a formula numeric field for hours and also for the other field.

ToHours([my duration field])

Then you are comparing numbers to numbers.  you might also want to round

round(ToHours([my duration field]),0.1)

as comparing fields to be equal can be messed up if there are small trailing decimals.