Hi,
I am having a problem with a field rule in my table which I believe has to do with a limitation on the length of the field rule. The current field rule is as follows:
CASE(ACCOUNT_TYPE="Commercial".AND.COM_EST_MO_USE=LOOKUPN("F","1","Com_min_use3","xacndata","Key"),LOOKUPN("F","1","Com_interstate_3","xacndata","Key")*CC_INTERSTATE_MIN,ACCOUNT_TYPE="Residential".AND.CC_INTERSTATE_MIN>LOOKUPN("F","1","Res_break_pt","xacndata","Key"),LOOKUPN("F","1","Res_plan1_rate","xacndata","Key")*CC_INTERSTATE_MIN,ACCOUNT_TYPE="Residential".AND.CC_INTERSTATE_MIN". Then, when I add the full path to the table references in each of the Lookup statements I get a the normal "Result: 0 Type:N" message (or equivalent depending on the calculated value) at the bottom of the large window in the Expression Builder as expected.
So, the complete field rule (with full paths included) which is properly evaluated by A5V5 is as follows:
CASE(ACCOUNT_TYPE="Commercial".AND.COM_EST_MO_USE=LOOKUPN("F","1","Com_min_use3","d:/a5v5/xacndata","Key"),LOOKUPN("F","1","Com_interstate_3","d:/a5v5/xacndata","Key")*CC_INTERSTATE_MIN,ACCOUNT_TYPE="Residential".AND.CC_INTERSTATE_MIN>LOOKUPN("F","1","Res_break_pt","d:/a5v5/xacndata","Key"),LOOKUPN("F","1","Res_plan1_rate","d:/a5v5/xacndata","Key")*CC_INTERSTATE_MIN,ACCOUNT_TYPE="Residential".AND.CC_INTERSTATE_MIN=LOOKUPN("F","1","Com_min_use3","d:/a5v5/xacndata","Key"),LOOKUPN("F","1","Com_interstate_3","d:/a5v5/xacndata","Key")*CC_INTERSTATE_MIN,ACCOUNT_TYPE="Residential".AND.CC_INTERSTATE_MIN>LOOKUPN("F","1","Res_break_pt","d:/a5v5/xacndata","Key"),LOOKUPN("F","1","Res_plan1_rate","d:/a5v5/xacndata","Key")*CC_INTERSTATE_MIN,ACCOUNT_TYPE="Residential".AND.CC_INTERSTATE_MIN
I am having a problem with a field rule in my table which I believe has to do with a limitation on the length of the field rule. The current field rule is as follows:
CASE(ACCOUNT_TYPE="Commercial".AND.COM_EST_MO_USE=LOOKUPN("F","1","Com_min_use3","xacndata","Key"),LOOKUPN("F","1","Com_interstate_3","xacndata","Key")*CC_INTERSTATE_MIN,ACCOUNT_TYPE="Residential".AND.CC_INTERSTATE_MIN>LOOKUPN("F","1","Res_break_pt","xacndata","Key"),LOOKUPN("F","1","Res_plan1_rate","xacndata","Key")*CC_INTERSTATE_MIN,ACCOUNT_TYPE="Residential".AND.CC_INTERSTATE_MIN". Then, when I add the full path to the table references in each of the Lookup statements I get a the normal "Result: 0 Type:N" message (or equivalent depending on the calculated value) at the bottom of the large window in the Expression Builder as expected.
So, the complete field rule (with full paths included) which is properly evaluated by A5V5 is as follows:
CASE(ACCOUNT_TYPE="Commercial".AND.COM_EST_MO_USE=LOOKUPN("F","1","Com_min_use3","d:/a5v5/xacndata","Key"),LOOKUPN("F","1","Com_interstate_3","d:/a5v5/xacndata","Key")*CC_INTERSTATE_MIN,ACCOUNT_TYPE="Residential".AND.CC_INTERSTATE_MIN>LOOKUPN("F","1","Res_break_pt","d:/a5v5/xacndata","Key"),LOOKUPN("F","1","Res_plan1_rate","d:/a5v5/xacndata","Key")*CC_INTERSTATE_MIN,ACCOUNT_TYPE="Residential".AND.CC_INTERSTATE_MIN=LOOKUPN("F","1","Com_min_use3","d:/a5v5/xacndata","Key"),LOOKUPN("F","1","Com_interstate_3","d:/a5v5/xacndata","Key")*CC_INTERSTATE_MIN,ACCOUNT_TYPE="Residential".AND.CC_INTERSTATE_MIN>LOOKUPN("F","1","Res_break_pt","d:/a5v5/xacndata","Key"),LOOKUPN("F","1","Res_plan1_rate","d:/a5v5/xacndata","Key")*CC_INTERSTATE_MIN,ACCOUNT_TYPE="Residential".AND.CC_INTERSTATE_MIN
Comment