Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Not clear what the problem is. From your description, it could be
if(QUARTER>9, <result if true>, <result if false>)
better to use a fixed length field
or change QUARTER to num(QUARTER,'000')
you could assign an ID to the Quarter and then replace it in your substring count
=SubStringCount(Concat(QUARTER_ID, '|'), 'ID_11')