Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
You can give this a shot as well:
=Interval(max({$<widget1=p({<widget1 = {'*?'}>})>}PurchaseTime)-(vReloadTime),'hh:mm')
Best,
S