Can any one help why this is giving error.

[ryan]

['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.

[Gregor Koch]

Hi

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

[ryan]

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.

[tomok]

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

[ryan]

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.