Search results for query: *

Okay so I need to find how many make up the array - so I have a distinct count included, but I get an error on this saying it needs to be an integer between 1 and 1000. Whileprintingrecords; global stringvar array my_array; global numbervar n := distinctcount(my_array); global numbervar...

Cannot replace n with a number because I don't know the number. Thanks so much! satinsilhouette

I haven't writtne an array display in about 5 years, but need to now. I am getting an error on the counter in the declare formula and in the populate formula for the counter_myfield: Declare formula: Whileprintingrecords; global stringvar array my_array; global numbervar counter_myfield:=0...

LBass - I didn't even think about that. That is like too simple. But Thank you! Thanks so much! satinsilhouette

I need to have an accounting period, which controls the grouping(s) rotate. Here is the example: Period 01 - Period 12 should be shown first in the report Period 02 - Period 01 Period 03 - Period 02 Period 04 - Period 03 Period 05 - Period 04, etc. so if the Posting date is in May, then April...

I need to fake count pages, but only its in a group. The page footer and header are not being used because they need a cover page and then a blank last page, so I have the report making a new page before the first group and after the group of information for that same group. That works...

I tried your exact array formula: whileprintingrecords; numbervar array x; datevar array y; numbervar i := i + 1; numbervar j := count({Sheet1_.Client},({Sheet1_.Client})); if i <= j then (redim preserve x[j]; redim preserve y[j];x := tonumber({Sheet1_.Account}); y := datevalue({Sheet1_.Date}))...

Thank you lbass, but it comes back with 'the word else is missing', which is where I was two days ago. So I am still stuck. By the way, your help to this forum is invaluable. I don't get to deal with this stuff on a daily basis, or very often at all. It's nice to know you are still on this...

I have an array set up to gather 2 sets of variables to fill and x and a y array. I don't have the detail section quite down, it is asking for a then on the if statement in XI R2. Thought you could leave it without a then piece to the statement. I am horrible at loops, how do I do this? Reset...

I see where you are getting that error, need to try to work around that. Yes you do need to have at least one positive and one negative number and all dates have to historically fall after the initial investment date. Thanks! Will try this, I wasn't quite there. Thanks so much! satinsilhouette

I need help setting up the array correctly to feed into the XIRR formula. I am not great with loops or do's and I think this is what the formula needs. Interesting problem, I haven't worked something this hard in a long long time. Thanks so much! satinsilhouette

Let me add to this: I have built a formula to populate an array for both a date field and a currency field. In Excel if you have 5 records from a1:b5 then XIRR looks like this: XIRR(A1:A5, B1:B5) Here is a version that works in Crystal that would require manual entry of new quarters numbers...

Okay so now how Lbass how did you fill the XIRR piece with the arrays? Thanks so much! satinsilhouette

Hmm, I can get the arrays to populate, supposedly this should work like excel. But in excel I can tell it to look at a range of values A1:A3 for example. So here is what I have so far, working off of an excel spreadsheet F1 is the customer name, F2 is the date field, F3 is the currency field...

I don't think you need a guess value. How did you do the array, that is what I am struggling with now. Thanks so much! satinsilhouette

For some reason it is not working? I guess you can manually enter the array values as in the example, but I don't think that is realistic since this is being read from a database over a period of time, many quarters, so then how does one populate the XIRR function with an array? Maybe that is...

Can someone explain better than the help section, how XIRR is used? If you have these figures with these dates: Group ABC: -10000 1/4/06 -10000 2/4/06 10000 1/5/05 30000 12/5/04 XIRR(values, dates) The report is grouped and the data above is an example of...

Seems to work bborissov - Thanks! Thanks so much! satinsilhouette

They are parameter feeds accepted by the report writing tool. Thanks so much! satinsilhouette

I found something on a SQL board about using a case statement in the where clause and haven't gotten it to work yet. Need: a data field that can have one choice, a range of choices or no choices. Control group is the field and it looks like: Control Group Start ______ Control...