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!

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

Running total %

Status
Not open for further replies.
SAWB

SAWB

Technical User
Jan 11, 2001
26
0
0
In an inventory report, I have two running totals. One counts on hand inventory by color (RT1), and the other by style (RT2).

I want a formula to calculate the percent of on hand by color in relation to on hand by style.

When I create a formula ((RT1 / RT2)* 100), the first color in a style is 100%, and the last one is correct.

How can I do this?
 
Sort by date Sort by votes
Try grouping by style then color. Then use summary of count.
 
Upvote 0 Downvote
I don't quite follow you on this one...
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

1tufgt
  • Locked
  • Question
Creating Chart with formula of running total of group?
Replies
6
Views
191
lbass
lbass
piovesan
  • Locked
  • Question
Using a Running Total as a Parameter 1
Replies
4
Views
92
lbass
lbass
hpl2001
  • Locked
  • Question
Calculating totals across a date range
Replies
10
Views
170
hpl2001
hpl2001
Bennie47250
  • Locked
  • Question
One to many link and order total 1
Replies
2
Views
61
Charliy
Charliy
gk17
  • Locked
  • Question
Add total for groups
Replies
1
Views
48
Charliy
Charliy

Part and Inventory Search

Sponsor

Back
Top