For HanDBase related topics that are not specific to one platform.
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.
- Posts: 36
- Joined: Wed May 27, 2009 10:53 pm
- Location: Veteran, Australia
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.
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.
- 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