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.
I'm currently using CR XI and have a report that has two Excel OLE objects. I copied them over from another report and they both showed up and printed perfectly on my new report. However, now one of them shows up as a black box. See the attached photo below for example: the top object is fine...
I created the two formula's you said but I have an issue with the second one. I am getting an error on the first part of the formula that says "There must be a group that matches this field." Here is exactly what I have (with the full real names):
sum({@Test Formula -...
Well the chart that I had working on another report had the date as the "on change" variable and where it was asking for the "show values" I had the percentages of the three questions and it worked great. I'm trying to replicate that and if I explaned it differntly, I apologize.
Sorry, thought I had everything explained. For the chart, it will be a bar chart where the x-axis is the questions (there are 3) and the y-axis is the date. The time frame will be from the parameter query that I set up. What I'm thinking the "on change" field should be would be the date and set...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.