Filter to show negative integers

For HanDBase related topics that are not specific to one platform.

Filter to show negative integers

Postby greyman56 » Tue Apr 11, 2017 5:17 pm

Hi all,

I am trying to create a view that only shows records where a calculated field (integer displayed in time format) is negative i.e less than 0

If the normal values are less than 23:59:59 then the standard filter will work by using IS NOT between 0 and 23:59:59, but in my case the values can be more than a days work of time.

Any ideas on how to achieve this? I have looked at conditional fields but cannot see how to use that to achieve the result.
Cheers, Graham
greyman56
 
Posts: 36
Joined: Wed May 27, 2009 10:53 pm
Location: Veteran, Australia

Re: Filter to show negative integers

Postby Treanot » Tue Apr 11, 2017 5:38 pm

Not that I know much and I'm just going off the top of my head. You could use a check box to give you either a 1 or 0. The value could be set with a condition then filter from there.
For example.
Negative? [conditional]
If [your calc field] is less than value 0
Then value =1
Else value = 0
This will give you a field "negative?" that has either a 1 or 0 for the individual entry. That is the same as a check box value.

Then you can filter your report using this column.

I haven't tested this but that one concept.
Good luck.
Treanot
 
Posts: 36
Joined: Mon Feb 08, 2010 3:15 pm


Return to HanDBase General Discussion

Who is online

Users browsing this forum: No registered users and 1 guest

cron