a simple calculation - but I'm stuck

[caribejoe]

I can't get this calc to display results. The field "size" is calculated as:

If(gender = "women" & product = "longsleeve" , "sm, md, lg", "" or If(gender = "women" & product = "shortsleeve" , "xs, sm, md, lg, xl", ""))

Its Calculation result is "text", not calculated if empty, not stored. Gender and Product are popup fields supported by a value list.

But when I enter a selectioin in them, there are no data in the size field.

I must be doing somethng very simple that is wrong. Advice please?

[bruceR]

There are a couple of problems. You're mixing up the concatenation operator "&" with the logical operator "and" for one thing. This should do it;

Case(

gender = "women" AND product = "longsleeve" , "sm, md, lg",

gender = "women" AND product = "shortsleeve" , "xs, sm, md, lg, xl"

)

Some problems with your original statement:

If( gender = "women" & product = "longsleeve"

evaluates as follows for women, lonsgleeve:

if (gender = "women1", "sm, md, lg", "" or If(gender = "women0" , "xs, sm, md, lg, xl", ""))

Which boils down to:

if (gender = "women1", "sm, md, lg", "" or "")