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!

  • Congratulations Mike Lewis 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. stcholly

    Multiple Sort Criteria - formula error

    I was able to get the "mm/dd/yyyy" to sort correctly. My only adjustment to the lbass's reply was the dollar amount sorted by the first digit only. I was able to fix by convering the totext({MASTER_JCM_JOB.Revised_Contract_Amount},2) to...
  2. stcholly

    Multiple Sort Criteria - formula error

    I'm trying to write a report with multiple sort options. It is telling me that the default: "" needs to be a date field. If I put a date field then it tells me the last three lines need to be a number. What is the proper fix? //Output 1st sorting criteria if count({?Sort Conditions})>=1 then...
  3. stcholly

    Formula Review

    Here is a sample of a "transaction log"... Cat TranDate Tranaction Type Amt 06-s-074 Our Job-Palm Beach, FL 01-710 Cost Code Description 12-31-06 Percent Complete 100.00 M 12-31-06 JC Cost 53.73...
  4. stcholly

    Formula Review

    dgillz - I appreciate your time (and patience) today. I'll try to explain the situation better... With Timberline, when you enter a job cost, it creates a transaction record. The transaction 'type' depends on how the data was entered. For example, when you enter a commitment in Timberline...
  5. stcholly

    Formula Review

    Thank you dgillz, However, {CURRENT_JCT_TRANSACTION.Cost_Code} is not the null value. The {CURRENT_JCT_TRANSACTION.Transaction_Type} = "Committed cost" could be null in certain instances. How do I test for a null value if it is not a field, but a formula? (Sorry, not very savvy in...
  6. stcholly

    Formula Review

    Crystal 10/Timberline Database I need help with the below (very lengthy) formula. I have an instance where my "01" number may or may not have a committed cost entry. For instance, cost code "01-710" has a commitment on one job, in which I want that amount to show on the report. On another...
  7. stcholly

    Most recent date needed

    This pulls in the maximum percentage, but not the entry for the most recent date/time. For example, I have a "Percent Complete" entered on 12/31/06 as 100% at 13:42, and then this was reduced to 0% on 12/31/06 at 14:27. I need to most recent entry pulled in, which in this case would be the 0%...
  8. stcholly

    Most recent date needed

    NEWBIE - Crystal 10, Timberline 9.2 I have this very basic formula to look up the amount for "Percent Complete". However, this may have more than one value, so I need to pick the value that has the most recent transaction date, but I'm not sure how to word it. if...
  9. stcholly

    help using a null field as a zero amount

    The "quick fix" did it. I never had to use that before, so I didn't realize it was there. I appreciate the kind response to my 'very newbie question!!!! Holly
  10. stcholly

    help using a null field as a zero amount

    Windows XP, Crystal 10, Timberline database. The following formula, in instances where AP costs nor JC costs have occured, is coming back with a 'blank' value vs. a zero. I'm having difficulty writing the formula to return a zero value in instances where an AP cost transaction nor a JC cost...
  11. stcholly

    Basic Formula - not recognizing date prompt field

    No record selection... At the detail level, it suppresses data if the Revised Contract Amount is < 0. The Group Footer suppresses using the following formula: {@YTD Costs Recognized} = 0 and {@YTD Revenue Earned} = 0 and {@Over-Billing} = 0 and {@Under-Billing} = 0 or...
  12. stcholly

    Basic Formula - not recognizing date prompt field

    When I move my end parentheses up a line, I lose all data. I end up with nothing but zeros.
  13. stcholly

    Basic Formula - not recognizing date prompt field

    I've been staring at this too long, and all my formulas are running together.... Any ideas why this formula is not giving me information within the date parameter? (Yes, I know my formula could be condensed). [wink] I'm using 5/31/06 as my cut off date, and it is still giving me entries that...
  14. stcholly

    Group Totals are okay, but Grand Totals calculate extra figures.

    LB- Tried your suggestion first, and it worked. I would have never thought the () would have made the difference. Again, you have bailed me out! Much appreciated! Teknogeek9 & synapsevampire - Thanks to both of you for the responses! HS [ponytails]
  15. stcholly

    Group Totals are okay, but Grand Totals calculate extra figures.

    CR10 - Trying to sum my Contracts by Year and then have a Grand Total in my Report Footer. The following is the formula (hidden) in my details section to accumulate: WhilePrintingRecords; numbervar RCyrtot; numbervar RCgrtot; if not({@YTD Costs Recognized} = 0 and {@YTD Revenue Earned} = 0 and...
  16. stcholly

    Running totals picking up all figures

    This worked! Except....The {@accum}, and thus the {@displyrtot} in GF#1, does not seem to reset at the end of the year. Did I overlook something? (Note: I've had beginner Crystal training only, so these formulas are a little outside my realm of training). Also, I want to sincerly thank you...
  17. stcholly

    Running totals picking up all figures

    In the Details Section (which is all supressed) are the following formulas: Job to Date Costs (as of cut-off prompt): IF {CURRENT_JCT_TRANSACTION.Transaction_Type} in ["AP cost","JC cost","PR cost","EQ Cost","IV Cost"] and ({CURRENT_JCT_TRANSACTION.Accounting_Date} <= {?Cut Off Date}) then...
  18. stcholly

    Running totals picking up all figures

    Many of the job total are built into the software. For those that weren't, I was able to sum the individual transaction, where certain criteria were met. I have not used running totals up to this point.
  19. stcholly

    Running totals picking up all figures

    Three Groups: GP 1 - Year of Job (which is first two digits of Job#) Formula: Left ({MASTER_JCM_JOB.Job},2) GP 2 - Transactions by Job {current_jct_transaction.job} GP 3 - Job {master_jcm_job.job} I was able to get my totals to work for each job, but I'm not having any luck getting...

Part and Inventory Search

Back
Top