I'm trying to generate a chart in Crystal Reports (version XI), and I can't get it to show the correct percentages.
I'm pulling the data from an Excel file and have created formulas where:
I have one formula set up to determine the first value (either yes or no), another to determine if it passes, and a 3rd to determine if it fails.
What I am trying to do is show the percent of pass and the percent of fail on a single line chart. Both values added together should equal 100% (since only "yes" records are included. "No" records are discarded.)
This should be divided out "weekly", but when I create the chart, it is showing me the same values for all 3 weeks of data I am testing with, which is 45% pass, 55% fail. But if I run the calculations manually, I get 50/50 for week 1, 42/58 for week 2, and 40/60 for week 3.
How can I get Crystal to show the correct numbers????
I'm pulling the data from an Excel file and have created formulas where:
- One value is either "Yes" or "No"
- Second Value is either >= 70 or <70
- If the two values are "Yes" and >= 70, then it is a "Pass"
- If first is "Yes" and second is < 70, then it is "Fail"
- If first value is "No" it is not included in "pass" or "fail"
I have one formula set up to determine the first value (either yes or no), another to determine if it passes, and a 3rd to determine if it fails.
What I am trying to do is show the percent of pass and the percent of fail on a single line chart. Both values added together should equal 100% (since only "yes" records are included. "No" records are discarded.)
This should be divided out "weekly", but when I create the chart, it is showing me the same values for all 3 weeks of data I am testing with, which is 45% pass, 55% fail. But if I run the calculations manually, I get 50/50 for week 1, 42/58 for week 2, and 40/60 for week 3.
How can I get Crystal to show the correct numbers????