combine a month with a number to use in a graph

[Halfcan]

OK,

I'm trying to create a bar graph with 6 bars.
For each month we have 2 uptime percentages - customer affecting, and non-customer affecting.
(C=customer affecting)
(N=noncustomer affecting)

It will look like this:

100% 95% 98% 97% 100% 10%

bar bar bar bar bar bar
--------------------------------------------------------
m1 C m1 N m2 C m2 N m3 C m3 N
Uptime% uptime uptime uptime uptime uptime

I have 6 separate uptime% formulas done, 2 for each month.(number)
I also have 3 separate monthnumber formulas: 01, 02, 03,....

Does anyone know a way to combine each of these together into a formula?

something like:
{month1} + {Uptime1 C} = 1st months uptime C
{month1} + {Uptime1 N} = 1st months uptime N
{month2} + {Uptime2 C} = 2nd months uptime C
{month2} + {Uptime2 N} = 2nd months uptime N
{month3} + {Uptime3 C} = 3rd months uptime C
{month3} + {Uptime3 C} = 3rd months uptime C

I then want to use this in graph with "On Change Of" {@formula name}

PLEASE HELP.

thanks,
HC

 

[Halfcan]

I'm using CR Version 8.5