Recent content by Oglesbay

I did try that, but I couldn't figure out how to find the average. I couldn't do it as a Running Total and when I tried to write the forumla, I kept getting errors. (I can't remember right now what I tried yesterday.)

I started a previous thread to figure out how to create the crosstab with my data. Now that we have auditors asking for some data, I need to figure out how to get it out of my data. Here is the link to the previous thread: http://www.tek-tips.com/viewthread.cfm?qid=1593712 Basically, this is...

For all those LiveCycle Designers (v8.2) out there, I have been able to create the dynamic form so the fields expand as needed, even going to another page if there is a lot of information. The problem I've run into however is that I've had to add more dynamic fields and have run out of space on...

And to clarify, the data fields aren't really "Class Name", "Instructor", and "Class Date." There are real fields in there and I just simplified what I was trying to show.

This is an Excel report that shows all the courses that have been taught in a 5 month period. It was exported (only options are HTML and EXL) out of a seperate applicaion which is why it looks the way it does. I'm trying to get it cleaned up so I can run totals, charts and all that other good...

Hello all. I am an Excel expert, but I've never had to do VBA coding in macro's, so I guess I'm not too much of an expert then! The issue I have is I have a report that looks something like this: Class Name Instructor Class Date Class...

lbass - You are right that there is nothing wrong with the formula, we just drilled down one group too many. By grouping by question that is what brought our error. If I removed that group and put the formula on the class, it worked perfectly. Thank you all for all your assistance with this issue!

Ok, I'll try to explain it again. A "perfect day" is when we get all Strongly Agree on ALL questions. The forumula above simply returns only the questions that all have Strongly Agree. For example, one class returned only two of the nine questions because in those two questions all of the...

Well, while I was hoping you guys could help me out I thought I came across the answer. What I ended up doing was doing a group select formula as follows: Sum({@stronglyagree},{table.question} = Count({table.name,{table.question}) and Count({table.name,{table.question}) >=4 This formula...

LB - The formula didn't quite work. It looks like it did sum up all of the 1's and only returned the classes that had 4 or higher responses, but the responses that came back still had some Agree, Neutral and Disagree in the responses. I think we're on the right track but I need to only return...

I was able to get assistance with my previous group selection formula and it worked wonderfully. The problem is that they changed how the data is stored and now it is in text where it was numbers in the past. Let me give you an example of my data. We are trying to find the "Perfect Days" in...

LB - Works like a charm now! All the data shows up but the problem with it is that the first three columns are only single digit numbers and the last three are comment fields with unlimited information. So the all the data can't be shown if I resize to fit the comments. Is there a way to change...

LB - I tried your formula and I get and error with the "else" section highlighted saying "A string is required here. Here is my formula exactly as I have it: if ({HealthStream_Evals.Evaluation} startswith "The most useful information" or {HealthStream_Evals.Evaluation} startswith "Of all the...

Going back to my original question, and your first post lbass, what if I also wanted to show data like this: Microsoft Excel Chad Oglesbay Question 1 Agree Question 2 Strongly Agree Question 3 Neutral Comment 1 The class was amazing and.... Kevin Schmitt...

Yeah, it is not checked. One thing I did find is that if I "Export" the report then it comes out just fine but if I Print the report using our PDF printer, that is when I have the issue. The weir part is I have been printing using the PDF printer for the last three years without issue.