Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

cr xi - calculate variance

Status
Not open for further replies.

campia

Technical User
Apr 20, 2007
77
BE
Dear,

I need to calculate the variance between totals of a same period (i mean months: january, february,march...) but diferent years (2006,2007,2008).

How can i do that in cr xi. I tried to use the function "variance" but i do not know really how to use it. can somebody help me please?

thanks

André
 
You can collect running totals that are specific to a particular month and year. At the end, do a comparison. Note that if a running total finds nothing it will be null, and an IsNull test should happen first if such an outcome is possible with your data.

The use of Crystal's automated totals is outlined at FAQ767-6524.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top