Search results for query: *

Should have realized that it need to compare NUMERICAL results vs the TEXT results I was comparing, correct?

LB, This has been great stuff - sincere appreciation! I have a twist I need to add when the resolution rate is in excess of 100% that it is 100%, but the following doesn't work. Thoughts? whileprintingrecords; numbervar adj; numbervar res; if adj=0 then "--" else //new----- if...

Aha! You are correct, LB! I was missing some ()s, and I now get the correct answers on the Fiscal YTD Report. The Calendar YTD Report will actually be set up as a separate report for publishing purposes. So rather than employ a parameter, I think we can just use a different formula for...

LB, That doesn't work for my Fiscal Year (starts 11/01/16) or Calendar Year (starts 01/01/17), so I likely gave you some bad info. Applying the above to the Fiscal Year Report which includes 11/16 and 12/16: @FY = 2017 Fiscal Year Actual Math: Months Elapsed 2 {Command.EOMDATE} 12/31/2016...

Thanks LB - yes, there are two versions of the report (well, actually, more but once I have the recommended solution, I can apply variations), but let's focus on the calendar year and fiscal year. Fiscal starts on 11/01. Calendar of course starts on 1/1. Sincere thanks!

LB, whileprintingrecords; numbervar adj; numbervar res; if adj=0 then "--" else totext(res%adj,1)+"%" Again, this is a brilliant solution. As noted, no longer exporting data only, and I have only a few minor extra columns. More importantly, the calculation for 'Resolution Rate' above...

LB, Only extra columns I'd like to eliminate are those that appear under the '--TOTALS--' column. I don't understand why this column would not generate one narrow column before one wide column encompassing the numbers below it as it is no different than the other columns. I event went so far...

LB, You're correct - you get formatting or you don't - in which case the calculation doesn't come through. I've combed other forums to confirm. I'll be working to eliminate as many extra columns as I can. Sincere thanks!

LB, I encountered an interesting problem using the above solution and exporting the Crystal Report to Excel (required): the 'resolution rate' number in Excel isn't the same as the correct one in Crystal. When I expert it to Excel, Data Only, and 'Typical' or 'Minimal' or 'Custom' formatting...

Brilliant and perfect response LB. Assume the key to the solution lies with 'whileprintingrecords.' That's less surprising than the display string - haven't used that before. Sincere thanks.

LB (or anyone else), I'm trying to finish up the same crosstab I noted above, but the last summarized field, 'Resolution Rate' equals: sum of @Total_Resolutions / sum of @Adjusted_Balance The problem is that in the cross-tab, the current calculation doesn't work. I am guessing because I...

LB, Man, I should have caught that - you are correct. Once the custom style is removed, everything aligns. I'm using CR 2008 v12. Thanks!

I have a relatively basic cross-tab report that has one 'row' named 'group' and one 'column' named 'officer.' I have 25 summarized fields (and likely more before I'm done). The 'descriptions' or 'text' fields don't come anywhere close to aligning with the summarized fields; specifically, they...

Kray, you nailed it and I realized it after the fact. I was trying to create a group off of a numeric field by recognizing the name of the field - my mistake! I'll pursue another technique using the above on a text field. Thanks for the help!

Thanks, Charily, but I had caught the missing " and used it and got the error I mentioned above. I also just tried: if "Accrual" IN totext(({table_date.balance_accrual})) then "Accrual Loans" else "Other" and I got no errors but all results were "Other," so while not yielding an error, it...

I appreciate the prompt response! The formula checker responded with "A string is required here" which makes sense since the field {table_date.balance_accrual} is a balance field and not a string field. So I am checking for text in the name of a balance field - that complicates the formula I'm...

The following formula works according to Crystal's formula checker but when I use it the formula to group in Crystal the error message is: Start position is less than 1 or not an integer if instr({table_date.balance_accrual},"Accrual","1")>0 then "Accrual Loans" else "Other" I will be adding...