Businessworks 2017 SP2
I want to calculate job margin on a custom report using JCjobs fields as follows:
((Billings-ActualCost)/Billings)*100
Is a calculation like the above possible in the report?
Any help would be greatly appreciated!
Businessworks 2017 SP2
I want to calculate job margin on a custom report using JCjobs fields as follows:
((Billings-ActualCost)/Billings)*100
Is a calculation like the above possible in the report?
Any help would be greatly appreciated!
Unfortunately, that is not an option when using our custom report program. We only allow you to sum a total/column. You would need to use an outside report writing program for that - like Crystal Reports. For more on custom reports, see KnowledgeBase articles #17826 How to create a Custom Report; #51705 Video: Reporting - How to create Custom Reports.
Thanks,
Coleen
Thank you for your help but I searched the site and have no idea where to find the 2 items you suggested??
These are KnowledgeBase articles. To use the KnowledgeBase go to support.na.sage.com. In the box that indicates "Seach the knowledgebase" type in what you are searching for, in this example enter the article #17826 or #51705. Then the article will display.
These are KnowledgeBase articles. To use the KnowledgeBase go to support.na.sage.com. In the box that indicates "Seach the knowledgebase" type in what you are searching for, in this example enter the article #17826 or #51705. Then the article will display.
*Community Hub is the new name for Sage City