Search results for query: *

I am using this formula to calculate the sum of the distinct loans: currencyVar TVOL; numberVar lcount;// := distinctcount({Data_Extraction.Loan Amount}); stringVar loannum := ' '; For lcount := 1 to distinctcount({Data_Extraction.Loan#}) Do ( If loannum = {Data_Extraction.Loan#}...

That is what I started with and I thought it should work as well; however, I'm not sure if it is data type that is causing the problem or what but it will not change from the current date even when selected. I'm going to check the data I am retrieving from the database because this is not right...

I tried both ways and for some reason the current date comes in for both the begin and end date. I tried without range and using discrete, that did not work. I've tried using range parameters and changing the date to not be the current date. I put in a big range, from the beginning of the year...

I'm confused, in selecting date when prompted by the user is what I need. Not sure why it forcing me to use the range date value.

I am running 8.5. I've changed the date parameter - range limited. I'm still having some problems. I'm testing it again and see if I missed something.

Well, it only gives the current date, not the date that I submit to run the report against.

date({HQSoldLoansAnalysis;1.Sold Date}) >= ({?Begin Date}) and date({HQSoldLoansAnalysis;1.Sold Date}) <= ({?End Date} ) and (if {?AE}='ALL' then {HQSoldLoansAnalysis;1.Account Executive}={HQSoldLoansAnalysis;1.Account Executive} else {?AE}={HQSoldLoansAnalysis;1.Account Executive}) This is...

yes

Also when selecting a date from the drop down menu, it remains on the current date. For instance. I select May 1, 2005, when I run the report, it run against the current date not May 1, 2005.

Thanks but it doesn't allow me to choose a different parameter field when linking other than the ?pm-?begin date

I having problems passing datetime parameter from my main report through the subreports. The data is not congruent all the way through, indicating that the date is not being pass correctly. Can anyone help?

I'm guessing that I would have to create a group formula to display the credit score range but I'm not sure how.

Thank you that helped. I created the formulas and I got the desired results. Ideally, the following is what I need more: Credit Score Units Volume 720+ 4 $425,000 719 - 700 6 $600,000 I got the Units and Volume to work based on the credit score range but...

I am trying to write a formula to compute calculations based on a range of FICO scores but I'm not sure how. I.E. Credit Scores 720+ Calculate units, Volume, Calculcate weighted averages, etc. I've already computed the calculations but I need to redo them based on a credit score ranges. Any ideas?

I am putting some documentation together and I was curious if there exists a Site Survey checklist when installing a new network infrastructure.

I am computing the weighted averages for field - Sell price with the car amount. This works but I need to take that computed weighted average and put that value to this formula (@spwav - 100/1)*1. I created a formula to do this but it doesn't change the value for each record in the cross tab. So...

I have another problem with the running total, if the results include other records it doesn't provide a grand total. It gives me $0.00. Any suggestions?

I was able to get it to work, disregard previous posting. Thank you guys for posting valuable information.

I haven't been able to get this work. Can someone help, please?

I have a problem with my grand total. The distinctcount(id) works fine but when I sum(totalamount), (id), the grand total sums in the duplicate records. How do I fix this?