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

# HFM Rules - effective dating

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.

• ###### 1. Re: HFM Rules - effective dating

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