Forum Stats

  • 3,872,944 Users
  • 2,266,491 Discussions
  • 7,911,391 Comments

Discussions

Possible Block Creation Problem - Not Sure

708875
708875 Member Posts: 56
edited Nov 4, 2009 10:13PM in Planning and Budgeting
Account 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

Answers

This discussion has been closed.