Hi,

I am drilling into a table in our software and the field is an array.  I am using Crystal XI.

The data held there is sales numbers for each month.  I want to be able to for any month of my choosing be able to pull the data that relates to that particular month.  So in the data below, if I wanted the sales for April, I would get as a result 35865.9.


0;0;0;35865.9;68436.95;0;0;0;0;0;0;0;0
(This data array is in field name 'dollars-shipped')


I will be manipulating that data to determine margins and cost of goods, so would need to be able to use this Array Read in formulas too.

 Thanks for your help! 

Edited by jkaufman - 20 May 2009 at 7:17am

I am not sure if that would work, as the array data is a field within a table, unless i did a formula to add the semi colon to end of the field.

But as I want this report to be run each week throughout the year, it would need be able to read whichever month I chose and i have limited knowledge of using loops.

EDIT:

i received an answer on a different forum and it works great, but wanted to post it here for anyone who may stumble across this post.

 create a formula as below with a parameter {?Month Selection} as below

local stringvar array x;
x:=split({oe_hist_cust.dollars-shipped}, ";");
tonumber(x[{?Month Selection}]);


Edited by jkaufman - 20 May 2009 at 8:12am