Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. reneek1

    Summarise a formula field in crystal reports

    Thank you! Works PERFECTLY!!!!
  2. reneek1

    Summarise a formula field in crystal reports

    Sorry - more details: The report is grouped by calendar month. @Trade Cap formula is: {@Trade Capacity per Month}-Sum ({ps_20MonthSpreadSum.MANHRS}, {ps_20MonthSpreadSum.Resource}) @Trade Capacity per Month formula is: {@Trade Numbers}*1720/12 @Forecast Hours Limited to Trade Capacity...
  3. reneek1

    Summarise a formula field in crystal reports

    Hi Pete Thank you so much for your reply. The first part of the formula works. The second part works perfectly for the first month (first group), but subsequent months is adding them to each other. For example the total for Oct is 6,402 which is correct, but the total for November is 22,925...
  4. reneek1

    Summarise a formula field in crystal reports

    hi there i need to total/summarise a formula field in crystal reports. i know crystal cannot do this but was hoping someone could help me with a work around. the formula in the column/field i need to summarise is: if{@Trade CAP}<0 then {@Trade Capacity per Month} else Sum...

Part and Inventory Search

Back
Top