month Array

[JamesFlowers]

Hi,

I am trying to extract to a cross tab, the amount of months left on a project, and pass to that cross tab a set figure for each month.

months left figure
3 3.7
5 34.7
7 23.0

I think I want to create an array to show

1 2 3
3.7 3.7 3.7

1 2 3 4 5
34.7 34.7 34.7 34.7 34.7

1 2 3 4 5 6 7
23.0 23.0 23.0 23.0 23.0 23.0 23.0

does this make sense?

Regards and TIA James

James Flowers
Crystal Consultant

 

[lbass]

If there are records for each month, I think you could create a formula like:

if {table.monthsleft} <= 3 then 3.7 else
if {table.monthsleft} <= 5 then 34.7 else
if {table.monthsleft} <= 7 then 23 else 0

Then use this formula as a summary field in your crosstab, using maximum as the summary.

-LB

 

[JamesFlowers]

lbass

there arent records for each month, just the number or months and a figure assigned to eacth month

eg 3 months @ 3.7 per month.

and I need to show

1 2 3
3.7 3.7 3.7

this figure will be varying as the months decrease as time goes by.

JRF

James Flowers
Crystal Consultant