1 of 1 people found this helpful
I think you're looking for a parameter. Right-click your field [Flow] and then click 'Create Parameter' and you'll get this box:
Change the Data Type to Integer. The range in your field will be automatically filed in. Change it if you want.
Then create a calculation to capture the user input and do whatever math you're wanting to do.
Hope this helps,
This is great, thanks! Is there a way to tie this into a filter?
Example: User inputs 306. The view would only show results from a flow of 306 cms.
We doin' a bit of blind-folded ping-pong here, but I'll take a swing, maybe I'll get lucky. Here's a simple way to use a forumula:
[My Integer Data] = [My User Selected Integer Parameter]
If you put this on the filter shelf and set it to True then it will in effect filter your data to just that one value. And if that wild swing didn't do the trick, you might want to read this:
and this one specifically
For more specific help, we'll need a sample packaged workbook.
Thanks, the links had an example that was basically the same scenario I am looking at. This online help book is really good, I'll now have another place to look for solutions.
I simply needed to create a calculated field:
Then made filtered to only show the "yes" values.
I appreciate the help, sorry if it felt a little blind.
Yeah they are in (have been) in the process of rewriting the online help and it is getting better all the time. It's in my bookmarks and the first place I look. The other place to look for stuff is the Knowledge Base.
Beware, with both of these you still might have to log in again, especially after you do a search. But have faith the second time around your search will produce a search and not just another login screen.