x Want to participate? Join the group to interact
  • State Verified Answer
  • Replies 2 replies
  • Subscribers 240 subscribers
  • Views 1421 views
  • Users 0 members are here
Browse Forums
Sage 100 Contractor Announcements
119
topics
57
replies
Sage 100 Contractor General Discussion
1k
topics
4k
replies
Sage 300 CRE Announcements
168
topics
526
replies
Sage 300 CRE General Discussion
3k
topics
8k
replies
Sage Construction Management Announcements
4
topics
0
replies
Sage Construction Management General Discussion
15
topics
20
replies
Sage Estimating Announcements
39
topics
3
replies
Sage Estimating General Discussion
188
topics
442
replies
John M Jankowski

Crystal Reports - JCT Current Transaction File

SOLVED
Posted By

Making some changes to a Job Cost report in Crystal based on Category. I have been trying to get a formula to works that DIVIDES a calculated JTD Cost by Total Estimate. Is it possible to use DIVISION in a JCT Current Transaction report?

  • 0
    verified answer

    You will need to create Summary totals to divide by properly - remember to condition for zero or you will get an error when you divide if one of the totals is zero - good luck

    if you have additional questions feel free to contact me at bill@kormoski,com

  • 0

    John and Bill,

    Thank you both for your participation in the Sage City community!  I have incorporated Bill's verified answer into knowledgebase article 48115 for future reference.

    Thanks,

    Angie

    Senior Customer Support Analyst, Sage Construction and Real Estate

    Sage North America

*Community Hub is the new name for Sage City