Conditional Expression column display

[Anonymous]

Hi All

I am facing problem with conditional statement when QUARTER exceed than 9 (10, 11, 12, ...).

QUARTERS are number.

  =SubStringCount(Concat(QUARTER, '|'), 11)

If anybody know alternative for this?

Thanks

[Anonymous]

Not clear what the problem is.  From your description, it could be

if(QUARTER>9, <result if true>, <result if false>)

[maxgro]

better to use a fixed length field

or change QUARTER to num(QUARTER,'000')

[ramoncova06]

you could assign an ID to the Quarter and then replace it in your substring count

=SubStringCount(Concat(QUARTER_ID, '|'), 'ID_11')