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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

WFP Departure undo for two Forecast yrs

HENRY UGBARUGBAOct 8 2024 — edited Oct 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

Duplicate Post
This post has already been added here:
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Marked as duplicate
Added on Oct 8 2024
0 comments
17 views