Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

WFP Departure undo for two Forecast yrs

HENRY UGBARUGBAOct 8 2024

I want to modify this script to calculate for two forecast periods, it currently calculates for just one year (FY24) but deletes data for FY25

FIX ("OEP_Forecast", "OEP_Working", "EN1" ,"USD")

FIX ("EMP1" ,"J1")  
 
    FIX (FY24, @LEVMBRS( "Period", 0))  
        FIX("No Property")  
         
       "OWP\_Start Month"(  
           
           
         IF (("Yr-Index" == "Yr-Index"->{Year} and "Fiscal TP-Index" >= "Fiscal TP-Index"->@MEMBER(@CONCATENATE("HSP\_ID\_", @HspNumToString({Month})))) OR "Yr-Index" > "Yr-Index"->{Year})  
           
          "OWP\_Headcount" = 1;  
                    "OWP\_FTE" = 1;  
           
                IF(@ISMBR({Year}))  
                     
                  IF ("Fiscal TP-Index" >= "Fiscal TP-Index"->@MEMBER(@CONCATENATE("HSP\_ID\_", @HspNumToString({Month}))))  
                    "OWP\_Action" = 1;  
                    "OWP\_FTE" = 1;  
                    "OWP\_Start Month" = {Month};  
                   
                  ENDIF  
                     
                   ENDIF  
                     
                   ENDIF  
                 
               
        )  
        ENDFIX  
     ENDFIX  
 ENDFIX  

ENDFIX

Comments
Post Details
Added on Oct 8 2024
0 comments
118 views