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 derfloh 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. Shannon2008

    joining dates and numbers into one string

    This is probably a simple thing, but I can't seem to come up with the solution. I need to join three fields to print in a text file as one continous string and the date field must be reformatted to match the specs of the file. Example 123456789 10/13/2009 44455 The result I need is...
  2. Shannon2008

    date range in a nested if then else formula

    Good Afternoon All, I am trying to write a formula that returns a value of "Fiscal 08" if the date in field {PRTIME.PER_END_DATE} is between 2008,03,01 to 2009,02,28 and if the same field {PRTIME.PER_END_DATE} is between 2009,03,01 and 2010,02,28 then "Fiscal 09". I can't seem to get the...
  3. Shannon2008

    Using a formula result in a formula

    This is probably quite easy and I think I am just missing something, but I can't seem to use a formula result in another formula. Sample if {@Division}= "abc" THEN{@NEER Value}+{@ Split}ELSE IF {@Division}="efg" THEN {@NEER Value}+{@ Split} ELSE IF {@Division}="hij" THEN {@NEER Value}+{@...
  4. Shannon2008

    Record Selection

    I am trying to select records based on the following formula: IF {COM_EMPLOYEE_SYS_ADMIN.TAX_PROVINCE}="AB" THEN IF{COM_EMPLOYEE_SYS_ADMIN.PAY_RATE}<10.00 THEN IF {COM_EMPLOYEE_SYS_ADMIN.TAX_PROVINCE}="NS" THEN {COM_EMPLOYEE_SYS_ADMIN.PAY_RATE}<9.00 The formula does not contain any errors...
  5. Shannon2008

    Boolean Required Here

    //the formula below gives me an error of 'A Boolean is required here' on the last line following ELSE. //What did I do wrong? //I want the formula to return the value of (PRTIME.PAY_SUM_GRP} provided the other conditions do not exist. //I tried two different ways of writing this, but keep...
  6. Shannon2008

    including and excluding values from a field based on another field.

    Hi, I am trying to exclude certain values from a field in order to determine a tax rate. The rate would be based on Province PRTIME.WC_STATE i.e. I would like to exclude code BLC from PAYDEDUCTN.DED_CODE if EE works in BC. Also, I would like to include certain values from a different field...
  7. Shannon2008

    CRX - using a formula in a formula

    I am trying to to write a simple formula that uses the result of another formula. For example: FORMULA 1 - IF {PRTIME.WAGE_AMOUNT}={PRTIME.RATE}then 0 else 8.35 This formula is working FORMULA 2 - {Result Formula 1} - {PRTIME.RATE} How do I reference the result from Formula 1?

Part and Inventory Search

Back
Top