hi everybody...

i just need some help on my thinking... which i think i got the right idea.... however results returned by the if statement is incorrect... can anybody shed some light...?

so here it comes... tried with an embedded case statement... for example when entering a 4 i will get a result "now it is time"... and it should actually say... not calculating that...

any help is much appreciated...

regards from germany...

If(IsEmpty(inv age) or inv age < "10",

"not calculating that",

If(inv age > "10" and inv age < "20", "just issued",

If(inv age > "21" and inv age < "30", "coming up",

If(inv age > "31" and inv age < "45", "now it is time",

If(inv age > "46" and inv age < "60", "action required",

""

)))))

Hi Jürgen,

this really should work:

Case

(

IsEmpty ( inv age) or inv age < 10 ; "not calculating that" ;

inv age < 20 ; "just issued" ;

inv age < 30 ; "coming up" ;

inv age < 45 ; "now it is time" ;

inv age < 60 ; "action required"

)

If "An operator is needed…" comes up, make sure you use the correct delimiter.

Before FM7, this could be either a comma or a semicolon, depending on your system

(it definitely was a semicolon on German systems).

Regards from the deep south