Possible Block Creation Problem - Not Sure
708875Nov 4 2009 — edited Nov 4 2009Account and Period are Dense. We basically want to put a qualifier in that if the 'Jan' intersection is not #Missing then it will not overwrite it with a zero. If it is #Missing then it can put the zero in the 'Jan' intersection..... Is this a block creation issue. I'm stumped.....
Why does this work just fine:
FIX( [Scenario_rtp] , [Version_rtp] ,[CCCC_rtp] , [Years_rtp] ,
[Activity_rtp] , [Resource_rtp] , [SAU_CAU_Facility_rtp],
"No_Account" )
"AN_Charge_Type" = 0;
ENDFIX
But this doesn't:
FIX( [Scenario_rtp] , [Version_rtp] ,[CCCC_rtp] , [Years_rtp] ,
[Activity_rtp] , [Resource_rtp] , [SAU_CAU_Facility_rtp],
"No_Account" )
"Jan"(
IF ("AN_Charge_Type" == #Missing)
"AN_Charge_Type" == 0;
ELSE
"AN_Charge_Type";
ENDIF;)
ENDFIX