Skip to main content
Question

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

  • October 25, 2018
  • 0 replies
  • 32 views
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.
This topic has been closed for replies.

QuickBaseJunkie
Forum|alt.badge.img+15
Jennifer,

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.

-Sharon
Jennifer,

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.
Terms & ConditionsAccessibility statement