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 strongm 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. kdavis6416

    Date Parameter for prior 3 month

    I am trying to set a data parameter for the prior 3 months. E.g. If I ran it today on 8/16/18 I need the data range to be 5/1/2018 - 07/31/2018. This is what I have so far and it only brings back last months data. _____________________________________________________________ if {?Relative...
  2. kdavis6416

    Find email-addressess with CSP Query Builder and other detail information about reports

    I am trying to pull this data from the CSP query builder. For some reason the email address does not show. I assume it is because I need to see each individual recurring event and not grouped. Does someone have a query that will show the report name , then the detail of what I have listed...
  3. kdavis6416

    Need Help with combining two formulas and getting a specific rating back

    % Coach fornula {#COACH}/{@Total Scored}*100 % Correct formlula {#YES}/{@Total Scored}*100
  4. kdavis6416

    Need Help with combining two formulas and getting a specific rating back

    //completed updating formulas 8/19/12 kd //EMAIL Support if {@Score Plan} = "Email Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Correct} < 66.5 then "Unsatisfactory" else if {@Score Plan} = "Email Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@%...
  5. kdavis6416

    Need Help with combining two formulas and getting a specific rating back

    I need help. Here is my situation. if {@Score Plan} = "Email Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Coach} < 66.5 then "Unsatisfactory" else if {@Score Plan} = "Email Form" and {Categories.category_caption} = "OPENING AND CLOSING" and {@% Coach} >= 66.5 and...
  6. kdavis6416

    Date parameter for YTD but not calendar year

    I am looking to create a Date parameter to dispay the YTD to be July 2011 to current.. Our Calendar year here is Jul - Jun.. not Jan to Dec.. So I cannot use the standard YTD function.. make sense...

Part and Inventory Search

Back
Top