Skip to Content
0
Former Member
Aug 21, 2009 at 09:13 AM

Chart based upon formula (shared) values

16 Views

I'm trying to create a chart based upon formulas referring to shared variables set by a sub reports. I do not get the correct values, why not?

First I created a simple chart in the group header 2:

On change of = Contract - Show = Formula: Count (, )

NO PROBLEM!

Then I created a second chart in the same group header:

On change of = Contract, Show = Sum of Formula: sum of @Amount

PROBLEM! All zero !?

The formula @Amount is only referring to another formula called @AmountShared: shared numbervar AMMOUNT

The formula @AmountShared is on group footer 3 and shows the correct values.

I have tried moving the charts to the group footer instead of header. Same result, the first charts shows values, the second does not.

I have tried other formulas, not referring to shared values, they do not have this

problem. So it must have something to do with the shared values which i need to use because of the complex data structure ...

How can I get these values in my chart?