Hi, All - Can anyone give me any help as to how to make my CASE statement for changing the periodid from 1 to JAN in the calculated fields section of SLB? Here is what I've come up with (don't laugh, I'm just an accountant who dabbles in sql) and it doesn't work. Thanks!! Kathryn
CASE {Account Summary History View:Period ID}
WHEN '1' THEN 'JAN'
WHEN '2' THEN 'FEB'
WHEN '3' THEN 'MAR'
WHEN '4' THEN 'APR'
WHEN '5' THEN 'MAY'
WHEN '6' THEN 'JUN'
WHEN '7' THEN 'JUL'
WHEN '8' THEN 'AUG'
WHEN '9' THEN 'SEP'
WHEN '10' THEN 'OCT'
WHEN '11' THEN 'NOV'
WHEN '12' THEN 'DEC'
ELSE 'ERROR'
END AS [MONTH]
from DYCUN..GL11111 GL11111
*This post is locked for comments
I have the same question (0)
