Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: npp83
  • Order by date
  1. npp83

    CR 2008: Re Group

    Ah hah! I got it. Nevermind about that previous question. Thank you.
  2. npp83

    CR 2008: Re Group

    Two Questions about that: 1. Does the custom formula field (@Replace) then only contain replace({LoanSummary.LoanNumber},"MUR","BRE") 2. What then would indicate the default behavior where if a loan does not equal MUR (a loan from another branch) use the standard...
  3. npp83

    CR 2008: Re Group

    When using the "replace" should I append replace({LoanSummary.LoanNumber},"MUR","BRE") in my Select Record statement? For example: {LoanSummary.CurrentMilestoneName} in ["Completion", "Funding", "Post Closing", "Shipping", "Sold"] and {LoanSummary.LoanFolder} like ["Closed Loans", "My...
  4. npp83

    CR 2008: Re Group

    As per my instructions, the loans from MUR must appear only in BRR (Brentwood). I personally don't know if this is possible to do with 1) dynamically pulled data straight from the DB Fields 2) even with reassignment in a formula field.
  5. npp83

    CR 2008: Re Group

    Hey guys I have a problem but first, let me issue a few bits of background information to help you understand my report a little better. A preamble to my problem: I have two groups: G1)Branch G2) LoanOfficer. Both of these were created using Database fields and are not formula fields. Loan...
  6. npp83

    Return a blank for undesired value

    I confirmed that it is a datetime.
  7. npp83

    Return a blank for undesired value

    As for your recent post, gmmastros. I did knock off that extra cast as per the convert. I am sure that wasn't doing anything either. Thanks. Now what of my recent post regarding River Guy's solution?
  8. npp83

    Return a blank for undesired value

    Well, neither of your responses work off-the-bat. However, I am pretty sure that both are on the right track. In either case I am still pulling the undesired date. That being said, I am pasting a larger clip of my query so you see how it is. Ive incorporated RiverGuy's solution, and as I said...
  9. npp83

    Return a blank for undesired value

    I have a series of date columns that are generating (on occasion) an un desired date (1900-01-01). I want to be able to isolate these dates per column and simply return a blank (' ') rather than a NULL or anything else. An example (partial) query I am using is currently this: + '|' +...
  10. npp83

    Rounding up decimal values < .5 to next whole value

    You know what. I just went ahead, closed down the report without saving, restarted the report - and everything works. I may have mistyped something. I thank you for sticking with me on this confusing problem. I am the only one that really knows CR at work and I am still learning it as well...
  11. npp83

    Rounding up decimal values < .5 to next whole value

    As I said in my previous post, they do appear that way in my s/s, and I even used a single piece of code to point to them both. That isn't the case, and its my fault for noit making that clear. Each one is unique. @loangroup and @loangroup2 both have their own code with their own unique...
  12. npp83

    Rounding up decimal values < .5 to next whole value

    I now see (after much sleep) where you might think I have duplicated variables. No, these have been renamed according to column. sumcnt and sumcnttwo etc... I am not sure what that leaves me with
  13. npp83

    Rounding up decimal values < .5 to next whole value

    Right, I know its .33. It is my sole objective to use a function to make it always round up to the next whole integer, in this case it would be 1. You both suggested RoundUp and ceiling as a means of doing this. I applied it and have yet to see how it works. But as you pointed out I have done...
  14. npp83

    Rounding up decimal values < .5 to next whole value

    The second screenshot on my website now includes where what formulas are placed where. What I am trying to do is calculate the averages by Branch (my first group (group #1) and if you take my two columns corresponding to sumcnt/sumcnttwo and cnt/cnttwo and perform an average on them, in many...
  15. npp83

    Rounding up decimal values < .5 to next whole value

    Visit my website (http://www.nppetre.com) I took it down and threw on screenshot of what my report looks like with the ceiling applied. you will notice if you do the addition on the numerator and divde by the denominator the result is obviously wrong given by the number of the numerator. Here...
  16. npp83

    Rounding up decimal values < .5 to next whole value

    Oddly enough, I implemented your solution and now where I should be getting values higher than 1, they all evaluate to 1. So even where I have numerators (when added up by hand) that are 8.xx and are being divided by say 3 I am getting just 1... Do I have to define the ceiling value threshold...
  17. npp83

    Adding an average by group

    Thank you. I did start a new thread. And do have a roundup() function. My version is in my new thread.
  18. npp83

    Rounding up decimal values < .5 to next whole value

    I could see how those would be useful but it seems those are hardcoded values. I would need them to be flexible for a variety of combinations. For example, hard-code my values like that, wouldnt I have trouble if I encountered a 10.09? .09 is less than one, but I still need it to bump up to 11...
  19. npp83

    Rounding up decimal values < .5 to next whole value

    CR 2008 12.2 If I have an averaged value, calculated from a formula field that is less than the tradditional .5 barrier for rounding up, how can I round up the next whole number rather than rounding it down? For example, I have 0.33 and I want it to be 1.0 and not 0.0 Somehow, need to...
  20. npp83

    Adding an average by group

    Alright, I've been told that 0 is a valid number so if I have this: 1 1 0 2 0 3 ---- My average should be 0.33 because those loans do need to be counted. Now, since .33 is a valid number, it needs to round up to the next whole integer. In this case .33 should be 1. If it were 2.21 it should be...

Part and Inventory Search

Back
Top