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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

percantage changes of the values in the same group

Status
Not open for further replies.

cuneyt

Programmer
Mar 3, 2003
42
AU
I'd like to see percantages of the values in the same group?

We can call that percantage change...

Example:
Group Footer1: Sum of Ado.Duration = day1 85
Sum of Ado.Duration = day2 68 20 %
Sum of Ado.Duration = day3 50 26.4%
Sum of Ado.Duration = day4 75 -50 %

Formulas are ((day1 - day2) * 100) / day1
(( 85 - 68 ) * 100) / 85 = 20
or
Formulas are ((day2 - day3) * 100) / day1
Formulas are ((day3 - day4) * 100) / day1
goes like that

Thanx
Cuneyt
 
I'd like to see percantages of the values in the same group?

We can call that percantage change...

Example:
Group Footer1: Sum of Ado.Duration = 85 day1
Sum of Ado.Duration = 68 day2 20 %
Sum of Ado.Duration = 50 day3 26.4%
Sum of Ado.Duration = 75 day4 -50 %

Formulas are ((day1 - day2) * 100) / day1
(( 85 - 68 ) * 100) / 85 = 20
or
Formulas are ((day2 - day3) * 100) / day1
Formulas are ((day3 - day4) * 100) / day1
goes like that

Thanx
Cuneyt
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top