Hi Everyone,
I need to add a multiplication factor which is based on an existence condition. In other words, if a value exists for the Plan Year use it in the formula otherwise take the value from the Current Year. Here is the formula I have written but can't seem to get to work:
IF (@ismbr("OFS_Calculated") and @ismbr("&OEP_PlanStartYr"))
IF(@ismbr("Mar") or @ismbr("Jun") or @ismbr("Sep") or @ismbr("Dec"))
"Salaire_Annuel"->"BegBalance"->"OFS_Direct Input"->"No Service Specialty" * (1 + "Augmentation"->"BegBalance"->"No Service Specialty"->"OFS_Direct Input") / 52 * 5 *
(IF ("ETP_%"->"No Service Specialty"->"OFS_Direct Input"->"&OEP_PlanStartYr"<> #MISSING) "ETP_%"->"No Service Specialty"->"OFS_Direct Input"->"&OEP_PlanStartYr";
ELSE "ETP_%"->"No Service Specialty"->"OFS_Direct Input"->"&OEP_CurYr";
ENDIF);
ELSE
"Salaire_Annuel"->"BegBalance"->"OFS_Direct Input"->"No Service Specialty" * (1 + "Augmentation"->"BegBalance"->"No Service Specialty"->"OFS_Direct Input") / 52 * 4 *
(IF ("ETP_%"->"No Service Specialty"->"OFS_Direct Input"->"&OEP_PlanStartYr"<> #MISSING) "ETP_%"->"No Service Specialty"->"OFS_Direct Input"->"&OEP_PlanStartYr";
ELSE "ETP_%"->"No Service Specialty"->"OFS_Direct Input"->"&OEP_CurYr";
ENDIF);
ENDIF
ENDIF
The part I need to check is this:
(IF ("ETP_%"->"No Service Specialty"->"OFS_Direct Input"->"&OEP_PlanStartYr"<> #MISSING) "ETP_%"->"No Service Specialty"->"OFS_Direct Input"->"&OEP_PlanStartYr";
ELSE "ETP_%"->"No Service Specialty"->"OFS_Direct Input"->"&OEP_CurYr";
ENDIF);
If account ETP_% has no value for the Plan Year, take the value from the Current Year.
Any ideas?
Thanks,
Kiran