Discussions

Expand all | Collapse all

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

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

    Posted 10-24-2018 20:09
    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.


  • 2.  RE: Problems using ""the value in the field"" to filter reports using a duration or summary total field

    Posted 10-25-2018 22:16
    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


  • 3.  RE: Problems using ""the value in the field"" to filter reports using a duration or summary total field

    Posted 10-25-2018 22:19
    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.