1 of 1 people found this helpful
Is that colum actually StdvsPerfect or sum([StdvsPerfect ]) or some other aggregation? Same for the other one?
Are these fields already aggregated? My guess is that these fields are at the row-level, so when you put them in the chart, they show up as SUM( PerfectUnits) ) and/or SUM( StdvsPerfect ). If either of these are true, that aggregation needs to be in your calculation as well.
Yes, you are both correct. I changed them to SUM() and it worked like I wanted. Thanks!