How can i make this formula correct..

[Wilnicm]

How can i make this formula correct i keep recieving the error "string is required here"
If {Command_1.AL_DESCRIPTION} = {Command_1.AL_DESCRIPTION}
then {Command_1.AL_DESCRIPTION}
else if {Command_1.AL_DESCRIPTION} = "Financials (FI)" then {Command.AL_DESCRIPTION} = ["FI","Letters DAY 1"]<---this is the part that is given me the problem...

I want to choose these fields " ["FI","Letters DAY 1"] out of this table and field {Command.AL_DESCRIPTION} When
This field string is equal in this table.. ---->{Command_1.AL_DESCRIPTION} = "Financials (FI)"

<Will The Great>

 

[dgillz]

You already had a thread on this did you not? If so please go respond to that thread and do not open another one.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html