7 Replies Latest reply: Nov 30, 2012 3:40 AM by Sharkie RSS

    Correct Fast Formula syntax.

    Sharkie
      Hi

      I got a Formula that uses a calculation from a function.

      IF years_service > 1 THEN
      (Max_Carryover = GET_KPMG_NET_CARRY_OVER(Effective_End_Date))

      Now this works for a certain group of people. lets say ID 80 and 81 and wont work for ID 82

      But if I change it to read
      IF years_service < 1 THEN
      (Max_Carryover = GET_KPMG_NET_CARRY_OVER(Effective_End_Date))

      it will work for 82 and not 80 or 81. This is expected

      But to incorporate everything I use

      IF (years_service > 1 OR years_service < 1) THEN
      (Max_Carryover = GET_KPMG_NET_CARRY_OVER(Effective_End_Date))

      It will only work for 80 and 81 again and not 82.

      Even if I do the following it still does not work

      IF years_service > 1 THEN
      (Max_Carryover = GET_KPMG_NET_CARRY_OVER(Effective_End_Date))

      IF years_service < 1 THEN
      (Max_Carryover = GET_KPMG_NET_CARRY_OVER(Effective_End_Date))


      OR

      IF years_service < 1 THEN
      (Max_Carryover = GET_KPMG_NET_CARRY_OVER(Effective_End_Date))
      ELSE IF years_service > 1 THEN
      (Max_Carryover = GET_KPMG_NET_CARRY_OVER(Effective_End_Date))

      Any clues?

      Thanks