Hi, I have two SUM fields very similar but one of them doesn't work properly and I couldn't find the problem.
The report show two SUM fields, but one of them shows an incorrect result.
This is the wrong field, where HOURS is the result of a SELECT. I have checked that de results of that select are correct, but not the sum
Any ideas? Thank you
The report show two SUM fields, but one of them shows an incorrect result.
This is the wrong field, where HOURS is the result of a SELECT. I have checked that de results of that select are correct, but not the sum
HTML:
<Field>
<Name>TotalHoursByWeek</Name>
<Section>6</Section>
<Text>SUM(HOURS)</Text>
<Calculated>-1</Calculated>
<Left>11820</Left>
<Width>705</Width>
<Height>285</Height>
<Align>8</Align>
<Font>
<Name>Arial</Name>
<Size>8.25</Size>
</Font>
</Field>
Any ideas? Thank you