Joined: 09 Aug 2010
Online Status: Offline
Posts: 53
Topic: Search parameters Posted: 15 Dec 2010 at 5:27am
I have a custom formula field which takes the @average turnover of three years. Is there anyway of making it filter out the results that have over a certain turnover, say £300,000 or introduing parameter that will search for requested values.
Joined: 01 Dec 2010
Online Status: Offline
Posts: 386
Posted: 15 Dec 2010 at 8:54am
Write a record selection formula like
{your_field} < {@average}
CR will then only display any of the records whose result is less than the value returned by @average
If you want users to specify the value, then you'll have to create a parameter based on that column, then write a record selection that is less than the value of the parameter.
Joined: 01 Dec 2010
Online Status: Offline
Posts: 386
Posted: 16 Dec 2010 at 2:46am
Something like that.
Although with a selection formula, you are specifying the records that you want to see (as opposed to a suppression formula, which specifies what you don't want to see)
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
