1 Reply Latest reply: Jun 17, 2014 6:37 AM by JTF85 RSS

    HFM Rules - effective dating

    2695069

      I'm having some issues in writing a rule to not run for a selected set of Entities for 5 months.  I have to essentially turn off the Net Income pull to Retained Earnings for a subset of entities for Nov/Dec 2013 through April 2014 (or make the amount zero).  Here is the rule itself:

       

      If pov_year = "2013" and pov_period = "Nov" Or pov_period = "Dec" and(HS.Entity.IsBase("40000", HS.Entity.Member)) Then

        HS.Exp "A#318199.I#[ICP None].C1#[None].C2#[None].C3#[None].C4#[None].C5#Base.C6#CLO = 0"

        ElseIf pov_year = "2014" and pov_period = "Jan" Or pov_period = "Feb" Or pov_period = "Mar" Or pov_period = "Apr"and(HS.Entity.IsBase("40000", HS.Entity.Member)) Then

        HS.Exp "A#318199.I#[ICP None].C1#[None].C2#[None].C3#[None].C4#[None].C5#Base.C6#CLO = 0"

        End if

        Else

        HS.Exp "A#318199.I#[ICP None].C1#[None].C2#[None].C3#[None].C4#[None].C5#Base.C6#CLO = A#NetIncome.W#YTD" & Tops

       

       

        End If

       

      My guess is that the problem resides in the Else function.  I'm trying to figure out the best way to get this to work without having to manually back out the Current Year Net Income data.

       

      Appreciate any help you can provide.

        • 1. Re: HFM Rules - effective dating
          JTF85

          Check your syntax, you have two end if's related to 1 if statement

           

          If pov_year = "2013" and pov_period = "Nov" Or pov_period = "Dec" and(HS.Entity.IsBase("40000", HS.Entity.Member)) Then

                 HS.Exp "A#318199.I#[ICP None].C1#[None].C2#[None].C3#[None].C4#[None].C5#Base.C6#CLO = 0"

          ElseIf pov_year = "2014" and pov_period = "Jan" Or pov_period = "Feb" Or pov_period = "Mar" Or pov_period = "Apr"and(HS.Entity.IsBase("40000", HS.Entity.Member)) Then

                 HS.Exp "A#318199.I#[ICP None].C1#[None].C2#[None].C3#[None].C4#[None].C5#Base.C6#CLO = 0"

          Else

                 HS.Exp "A#318199.I#[ICP None].C1#[None].C2#[None].C3#[None].C4#[None].C5#Base.C6#CLO = A#NetIncome.W#YTD" & Tops

          End If

           

          Regards

          JTF