Hi there, I need help with a problem in how the graphic is show in the chart. I have columns from different year. Let say Oct/11 - Nov/11 - Oct/12 -  Nov/12.  I grouped for month and year and the information mean % are correct. Also, I initialized the variable at the beginning of each group therefore, each group begin with 100%. I used the formula that calculates the % in the chart.  The problem is that just the first year e.g. Oct/11 begin in the 100% on the chart the another year begin showing the first value al 160% or 93%, etc. It look like thru the group has a deviation or a different that is not show in the report % values which look like the same that the number below. Each month, shows values for 30 or 31 days % goes down until 45% or 27% but the graduation is very similar for year than the chart lines goes down touch one line with the other. 

 

 

shared numbervar gNum_o;
gNum_o := {'PPS_Oct_12_'.F17};

 

This formula calculate the % , is used in the detail section and thru andother formula in the chart:

 

whileprintingrecords;
shared numbervar gNum_O;
Local numbervar nCol_o_per;

nCol_o_per := ({'PPS_Oct_12_'.F17} / gNum_o) * 100

 

With this formula create and other one to use the option don't summary.

This formula goes in the Show Values;

 

({@OCol_per}) / 100

 

On change of,  I used two data a formula and a date field;  

 

totext({'PPS_Oct_12_'.Date},"dd")  to show one line for the first month and put a second one, the field date to show the others lines. 

 

{'PPS_Oct_12_'.Date}

 

 

Any suggestion to try to get the beginning of the line together at 100%

Thanks