Search results for query: *

Thank you MzKitty! Problem solved.[2thumbsup]

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

Thank you both!! It's working.

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

The nested formulas are Division = IF {QUARTDED.PROCESS_LEVEL} startswith "B" THEN "abc" ELSE IF {QUARTDED.PROCESS_LEVEL} startswith "C" THEN "efg" ELSE IF {QUARTDED.PROCESS_LEVEL} startswith "I" THEN "hij" ELSE IF {QUARTDED.PROCESS_LEVEL} startswith "K" THEN "x" NEER Value = {?NEER...

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}+{@...

Thank you. That was easy!

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

Thanks LB that worked great!

//Thanks but now I get another error //it wants a ) on THEN //the error is 'The ) is missing' //any idea? local StringVar Array Prov_Worked; IF {PRTIME.PAY_SUM_GRP}='LOU' THEN IF {PRTIME.WC_STATE}=Prov_Worked THEN {PRTIME.PAY_SUM_GRP} = '0' ELSE IF (({PRTIME.WC_STATE})<>Prov_Worked THEN...

//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...

Thanks LB!

EE# PROV E_CODE E_AMT D_CODE D_AMT TOTAL PREM 149 AB A 375.16 B .64 375.80 2.51 149 AB B 200.00 B .58 200.58 1.34 148 BC C 310.00 B .61 310.00 1.76 148 BC D 150.00 B .53 0.00 0.00 Where PROV = BC do not include D_CODE...

Sorry, I am new at this. EE=employee and BC=British Columbia SAMPLE DATA If EE works in BC, then do not include deduction code 'B' in calcuation - and if EE works in BC then include earnings codes 'A','B','C' in calculation, else if EE works in AB (Alberta) then include deduction code 'B' in...

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

I figured it out. Thanks anyway.

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?