Using string with hyphen in it

[kgraham25]

Hi

I'm trying to set colours on a chart using the following expression:

IF(Age = '<25',

     $(vRed),

     IF (Age = '25-34',

     $(vGreen),

    IF (Age = '35-50',

     $(vYellow),

     $(vGrey)

     )

     )

)

For some reason I don't think it likes the hyphen in the string ('25-34'). Does anyone have any ideas on how to get around this?

Thanks!

[Anonymous]

i fthe hyphen is part of the string try the following:

IF(Age ="'<25'",

     $(vRed),

     IF (Age = "'25-34'",

     $(vGreen),

    IF (Age = "'35-50'",

     $(vYellow),

     $(vGrey)

     )

     )

)

[juraj_misina]

Hi Kelly,

can you be more specific on what happens or is not working? Hyphens in strings are perfectly OK, but you did not provide any problem description.

Juraj

[petter · Accepted solution]

There is no problem with a hyphen in a string like '25-34'.

Is your Age field a bucketed range already containing the literal strings    '<25' , '25-34' , '35-50' ?

However if your Age field is a number indicating Age then you will have to do this:

If( Age <25 ,

  $(vRed) ,

  If( Agr >= 25 AND Age <=34 ,

    $(vGreen),

    If( Age >= 35 and Age <= 50,

       $(vYellow),

       $(vGray)

    )

  )

)

[kgraham25]

Thanks Petter - that seems to have worked!

I thought the age bands were string, but turns out they were numbers!

[kgraham25]

Thanks Sebastian - I hadn't realised that my age variable was actually number and not string.