Re: Need help to create a formula

[Michael Young <meyoung@siu.edu>]

Dr. Metz,

Here's a column formula that worked for a simplified version of your situation (just three food columns):

t3 = If( :hot dog > 0, "hot dog;", "") || If( :pizza > 0, "pizza;", "") || If( :pop > 0, "pop;", ""); Substr(t3, 1, Length(t3) - 1)

You just concatenate the results of a series of If statements.  The result is assigned to a temporary variable (t3 in my example) only because the concatenation method will leave you with an extra semicolon at the end; the substr removes that extra semicolon. 

If I understood your problem correctly, this should do the job.

Cheers,

Mike

-- 

Dr. Michael E. Young            http://www.siu.edu/~psycho/bcs/young.html
Southern Illinois University   618/453-3567
271F Life Sciences II                      
Carbondale, IL 62901-6502