TM1 Forum

['Budget','ContainerCount','BudgetedVoyage','FinalVal']=S:
IF(['Budget','ContainerCount','BudgetedVoyage','OverwriteVal'] @<> '', ['Budget','ContainerCount','BudgetedVoyage','OverwriteVal'],['Budget','ContainerCount','BudgetedVoyage','BudgetVal']);

When I save the rule, I am getting error - " Syntax error on or before logical expression"

All the three elements(FinalVal, OverwriteVal, BudgetVal) are String Type.

Can anyone help what was the reason behind this.

Thanks in advance.

Hi

You need to use the DB(cube, ...) syntax rather than the [] syntax for String elements.
Cheers

Gregor Koch wrote:Hi

You need to use the DB(cube, ...) syntax rather than the [] syntax for String elements.
Cheers

Thanks George, I am able to get the result. Now I have another problem, when I include Skipchek & Feeder statments

SKIPCHECK;
['Budget','ContainerCount','BudgetedVoyage','Budget_Final']=S:
IF(DB('BD_CargoMixUsed4Calc','Budget',!SF_InterlineFlag,!SF_BorneFlag,!SF_Direction,'ContainerCount',!SF_Service,!BD_Period,'BudgetedVoyage','Budget_Overwrite') @<> '',
DB('BD_CargoMixUsed4Calc','Budget',!SF_InterlineFlag,!SF_BorneFlag,!SF_Direction,'ContainerCount',!SF_Service,!BD_Period,'BudgetedVoyage','Budget_Overwrite'),
DB('BD_CargoMixUsed4Calc','Budget',!SF_InterlineFlag,!SF_BorneFlag,!SF_Direction,'ContainerCount',!SF_Service,!BD_Period,'BudgetedVoyage','Budget_Calc'));

FEEDERS;
['Budget','ContainerCount','BudgetedVoyage','Budget_Overwrite']=>
DB('BD_CargoMixUsed4Calc','Budget',!SF_InterlineFlag,!SF_BorneFlag,!SF_Direction,'ContainerCount',!SF_Service,!BD_Period,'BudgetedVoyage','Budget_Final');
['Budget','ContainerCount','BudgetedVoyage','Budget_Calc']=>
DB('BD_CargoMixUsed4Calc','Budget',!SF_InterlineFlag,!SF_BorneFlag,!SF_Direction,'ContainerCount',!SF_Service,!BD_Period,'BudgetedVoyage','Budget_Final');

I Can see values under Budget_Final element reflecting from Budget_Overwrite. But when I click 'Supress Zeroes", I cannot see the element - 'Budget_Final' in the any view.
Can u please help me in this regard.

You have to use the FEEDSTRINGS statement to feed string values.

tomok wrote:You have to use the FEEDSTRINGS statement to feed string values.

oops I forgot to include that statement.

FEEDSTRINGS;
SKIPCHECK;
['Budget','ContainerCount','BudgetedVoyage','Budget_Final']=S:
IF(DB('BD_CargoMixUsed4Calc','Budget',!SF_InterlineFlag,!SF_BorneFlag,!SF_Direction,'ContainerCount',!SF_Service,!BD_Period,'BudgetedVoyage','Budget_Overwrite') @<> '',
DB('BD_CargoMixUsed4Calc','Budget',!SF_InterlineFlag,!SF_BorneFlag,!SF_Direction,'ContainerCount',!SF_Service,!BD_Period,'BudgetedVoyage','Budget_Overwrite'),
DB('BD_CargoMixUsed4Calc','Budget',!SF_InterlineFlag,!SF_BorneFlag,!SF_Direction,'ContainerCount',!SF_Service,!BD_Period,'BudgetedVoyage','Budget_Calc'));

FEEDERS;
['Budget','ContainerCount','BudgetedVoyage','Budget_Overwrite']=>
DB('BD_CargoMixUsed4Calc','Budget',!SF_InterlineFlag,!SF_BorneFlag,!SF_Direction,'ContainerCount',!SF_Service,!BD_Period,'BudgetedVoyage','Budget_Final');
['Budget','ContainerCount','BudgetedVoyage','Budget_Calc']=>
DB('BD_CargoMixUsed4Calc','Budget',!SF_InterlineFlag,!SF_BorneFlag,!SF_Direction,'ContainerCount',!SF_Service,!BD_Period,'BudgetedVoyage','Budget_Final');

I Can see values under Budget_Final element reflecting from Budget_Overwrite. But when I click 'Supress Zeroes", I cannot see the element - 'Budget_Final' in the any view.
Can anyone please help me whether anything to be corrected in feeders?

Thanks in advance.