Page 1 of 1
Calculating Gross Profit error.
Posted: 24 Apr 2012, 11:12
by pheppi
Ok so i am wanting my data to calculate gross profit.
So i have made an exception saying:
'tblJob'.'NetBilled' - 'tblJobCost'.'TotalNet'
So it takes away my Sales from my Labour/Plant costs etc.
Although this is multiplying it by 15.
Anyone help?
Re: Calculating Gross Profit error.
Posted: 24 Apr 2012, 12:24
by brucedenney
I think you are doing this in a footer, as a result this is the sum of lots of repeating entries in a details section (my guess would be 15 repeating detail entries) the details section may be hidden and this may be what is confusing you.
Re: Calculating Gross Profit error.
Posted: 24 Apr 2012, 12:31
by pheppi
Thanks for that, how do i view the detail entries, i think your right
Re: Calculating Gross Profit error.
Posted: 24 Apr 2012, 12:50
by pheppi
to confirm its repeating 15 times, but i dont know how to bring it to once lol
Re: Calculating Gross Profit error.
Posted: 24 Apr 2012, 13:15
by pheppi
Iv attached what i have done.
Re: Calculating Gross Profit error.
Posted: 25 Apr 2012, 13:56
by brucedenney
Right click on Expr1 and choose properties, in function drop down box change it from sum to none