×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

#### Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

# Creating Chart with formula of running total of group?

## Creating Chart with formula of running total of group?

(OP)
I was wondering if there is a good work around for creating a chart that is from a formula (%) from 2 running totals. I know the issue is that with charts you can't create graphs from the formulas of running totals since charts are rendered beforehand.

I currently have couple of groups already setup in which I'm counting the running total for. Then using the running totals to get a percentage that I want to graph by month.

Group 1 - Name
Group 2 - Mo/Yr
Running total x & y
x / y * 100 = percent

I can chart the running totals but not able to chart the percentage in a graph and get the value is a variable error.

### RE: Creating Chart with formula of running total of group?

What is the purpose of the running totals? How are they set up? There may be a way to use a traditional inserted summary so that you don't have this problem.

-LB

### RE: Creating Chart with formula of running total of group?

(OP)
Reason is the summary isn't calculating to the correct numbers since I need to place conditions on if a row should equal 1 or not.

Example.

My grouping in the initial post was incorrect.

Group 1: mo/yr
Group 2: Name
Value 1
Formula 1 if Value 1 > 0 then 1 else 0
Sum of Formula 1
Formula 2 if Value 1 > 0 then 1 else 0
Sum of Formula 2

Footer 1: Formula 1 / Formula 2 = Percent.

### RE: Creating Chart with formula of running total of group?

(OP)
The other option I tried is just with a standard formula where I determine if the previous is a duplicate or not. So within that formula I check if {@Name} = Previous {@Name} Then 0 else 1. But using that formula I don't have the ability to insert a summary either.

### RE: Creating Chart with formula of running total of group?

This isn't clear to me. I don't know what you mean by Formula 1 and Formula 2--how do they relate to running totals? Are you trying to sum an amount but only if it isn't a negative number? Or is this simply a check for zero values that would cause a division by 0 error? Or is is that you have duplicate values that you are trying to eliminate from the sum?

Please answer these questions and then show some sample data with column labels at the detail section.

If you are using formulas, show the actual contents of the formulas. If you are using running totals, show how they are set up--summary field, type of summary, evaluation section, reset section.

-LB

### RE: Creating Chart with formula of running total of group?

(OP)
Hopefully this helps. Initially I was thinking running totals but your comment about traditional summary I was tried to insert a formula into my report but it doesn't allow me to "insert" summary on formula's.

Name Month IsValid Name Count (formula)
Joe Jan 1 1
Joe Jan 1 0
Bill Jan 0 1
Jeff Jan 1 1
Jeff Jan 1 0
Jeff Jan 1 0
Mary Jan 0 1
Mary Jan 0 1
Leon Jan 1 1

Need sum of IsValid and Name Count to create a percentage. IsValid / Name Count = percent. I would only count the IsValid where Name Count = 1.

### RE: Creating Chart with formula of running total of group?

You should be able to insert summaries on your formulas, so please copy the contents of your formulas into this thread so I can troubleshoot this.

-LB

#### Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

#### Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Close Box

# Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!