Record Count changes when I add Chart

[fnpuff]

There are 273 Programs in our database (SQL). I can display this with a summary count of Programs.ProgramNumber. Problem I'm having is when I insert a pie chart using a count of the same field above I get 274 as my total. Any suggestions? and does this happen often?

 

[fnpuff]

Note, I tried distinctcount and that did not help

 

[lbass]

Are you by any chance inserting the distinctcount on a conditional formula? If so, please share the formula.

-LB

 

[fnpuff]

No formula, testing this a on a new blank report. Olny thing I have on this report is the Chart.

Chart Data
on change of: regions.name-A
Show value(s): count of Programs.programnumber

 

[fnpuff]

Found out its a problem with a lockup table.

Thanks