Search results for query: *

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

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...

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...

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.

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...

I confirmed that it is a datetime.

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?

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...

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: + '|' +...

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...

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...

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

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...

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...

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...

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...

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

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...

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...

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...