Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Possible Block Creation Problem - Not Sure

708875Nov 4 2009 — edited Nov 4 2009
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details