Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago

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

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.
reports and charts

2 Replies

  • QuickBaseJunkie's avatar
    QuickBaseJunkie
    Icon for Qrew Legend rankQrew Legend
    8 years ago
    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
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    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.