Hi there,
I am having an issue with a report where I am trying to link a field which I have named on a level higher up as follows
The issue I have is that the RefHours is a set figure from another table included within my query but what appears to happen is that figure is multiplied by the number of files contained within 'Detail' giving the wrong result. (In the example below i have hidden 'Detail' for ease of viewing. The blue total should have read 4,658.00 not 19,008.00
Any ideas on how to correct this would be greatly appreciated.
I am having an issue with a report where I am trying to link a field which I have named on a level higher up as follows
The issue I have is that the RefHours is a set figure from another table included within my query but what appears to happen is that figure is multiplied by the number of files contained within 'Detail' giving the wrong result. (In the example below i have hidden 'Detail' for ease of viewing. The blue total should have read 4,658.00 not 19,008.00
Any ideas on how to correct this would be greatly appreciated.