Filtering out blank values

[#1]

Hello all,

I have been struggling with the best way to filter out blank values. In this report I am trying to measure the amount of time between a widget sale and reload time. This is what I am trying, but to no avail.

=Interval(max({$<widget1={'*'}>}PurchaseTime)-(vReloadTime),'hh:mm')

Any guidance would be great!

[Oleg_Troyansky]

if you are trying to filter out blank values in the field widget1, then you could use the following syntax:

=Interval(max({$<widget1={"=len(trim(widget1))>0"}>}PurchaseTime)-(vReloadTime),'hh:mm')

this search condition will only include widgets that have a value that's at least one character long.

[sunny_talwar]

You can give this a shot as well:

=Interval(max({$<widget1=p({<widget1 = {'*?'}>})>}PurchaseTime)-(vReloadTime),'hh:mm')

Best,

S