Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
7 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 ...
reports and charts
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 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.
Related Content