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?
Calculating Gross Profit error.
- brucedenney
- Site Admin
- Posts: 4631
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Calculating Gross Profit error.
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.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Re: Calculating Gross Profit error.
Thanks for that, how do i view the detail entries, i think your right
Re: Calculating Gross Profit error.
to confirm its repeating 15 times, but i dont know how to bring it to once lol
Re: Calculating Gross Profit error.
Iv attached what i have done.
Login to access the files attached to this post.
- brucedenney
- Site Admin
- Posts: 4631
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Calculating Gross Profit error.
Right click on Expr1 and choose properties, in function drop down box change it from sum to none
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Who is online
Users browsing this forum: No registered users and 1 guest