Hi,
can you please suggest me how to use the calculated variable in graph. When I tried using the calculated variable the results that are provided is way bigger than the expected.
Formula used -
if 'A', 'B' and 'C' are my objects from the query in which A is a measure and B is a dimension then in the crystal report i am using sum(A)/Sum (A,B).
I have used Group expert and grouped the data by 'B', 'C'. The graph I am having will be displayed under the Group header of 'C'.
Appreciate your help
Regards,
Kiran
If you want the numbers for just the C group, I would change the formula to something like this:
Sum(A, C)/Sum(A, B)
"Sum(A)" gets you the grand total for the report, not the total for the group where you're putting the calculation.
-Dell
Add a comment