solarachick
Technical User
Hello! I am attempting to replace a series of Excel line charts with Crystal BO 2008. Through the help of this forum I have been able to determine the average of a Running total and use Crystal's chart expert to add +/- one deviation.
The issue is that the numbers I need the deviations of are group (weekly)totals - so I am not able to write a formula to determine the deviations myself. If I could I would muliply the deviation by +/-2 and +/-3 and subtract or add to the average like I did in Excel.
Bottom line - how can I ask Crystal nicely to add four more lines to the chart; +/- 2 deviations and +/- 3 deviations of weekly sets of totals?
I have the formula to group the daily numbers by week that works well called MonToSun.
We in Alaska Thank you for your help!
Solarachick
The issue is that the numbers I need the deviations of are group (weekly)totals - so I am not able to write a formula to determine the deviations myself. If I could I would muliply the deviation by +/-2 and +/-3 and subtract or add to the average like I did in Excel.
Bottom line - how can I ask Crystal nicely to add four more lines to the chart; +/- 2 deviations and +/- 3 deviations of weekly sets of totals?
I have the formula to group the daily numbers by week that works well called MonToSun.
We in Alaska Thank you for your help!
Solarachick