ChrisNewsome
Qrew Captain
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Color coding formula based on another formula field
Chayce, I'm trying to do something similar but your last line above is missing a closing parentheses or something. I'm getting an error "expecting )," but i can't seem to figure out how to solve it. I've added the ), but the error just moves down to the </P> box with "expecting text." I've copied your formula and input my own fields, etc, otherwise I've made no changes. Any ideas?Re: Limit # of records in a table report
I appreciate the info. The goal is to make a report for the Sales dept that they can run on demand to see who our top customers are. I'm actually comparing their volume from this year to last year. Everything on the report is fine, I just don't need 300 results... just the top 15-20. The ranking formula attempted in this thread was done as a report formula instead of a field itself based on the earlier replies about slowing the system down. So the goal is something that can be run with one click, easily, by a standard user of the app, so I don't think the other options you outlined would work. I go back to my earlier comment - I can't believe it's not just a standard option to limit results to X number. Seems so basic. ------------------------------ Thanks, Chris Newsome ------------------------------Re: Limit # of records in a table report
I haven't. I typically assume that I've missed some simple thing first before I go that route. The thing is, it's not returning the correct results. I'm wanting to rank by the Won Value (YTD) field, and it ranks a customer that is at $277k at #1, and also a customer that is $91k at #1, which doesn't make any sense. I am going to submit a feature request though to simply add the ability to limit results to X number... that's really all I need it do: "Only show 20 records." Quick Base is amazing but at times I'm dumbfounded that simple things like this aren't easily achievable. ------------------------------ Thanks, Chris Newsome ------------------------------Re: Limit # of records in a table report
That's the thing that's frustrating - none of my records have the same volume, but it's still ranking many of them as 1, etc. (see the photo above) It doesn't seem to work and I can't figure out why. It's basically useless - I can sort the report by the column I'm actually interested in, I just only want to see the top 15 or 20, not all 2000 records. ------------------------------ Thanks, Chris Newsome ------------------------------Re: Limit # of records in a table report
Here is my formula: (64 is the FID for "Total Won Value (YTD)" and 62 is the FID for "Territory") var text QUERY = "{64.GT.'" & [Total Won Value (YTD)] & "'}AND{62.XEX.'Knoxville'}"; Size(GetRecords($QUERY))+1 Here's the results I'm getting: As you can see it's not sorting by that field at all. Also it returned 32 results for #s up to 15 and none of the numbers match. ------------------------------ Thanks, Chris Newsome ------------------------------
