Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trouble with a record name which having '
This is name of the field -------- Care Transitions (reporting Oct '14)
=if(DChart='Care Transitions (reporting Oct '&chr(39)&'14)',count({< [CAHPS Count Flag]={1}, [CAHPS Chart Domain]={'Care Transitions (reporting Oct '&chr(39)&'14)'}, [CAHPS Questions Flag]={1}, [$(vDateType) $(vDateUnit)],
[Numeric $(vDateType) $(vDateUnit)]={">=$(=num(Max([Numeric Previous-x $(vDateType) $(vDateUnit)])))<=$(=Max([Numeric $(vDateType) $(vDateUnit)]))"}
>} Distinct [Survey ID]),0)
This expression is working with other filed names but not for the 'Care Transitions (reporting Oct '14)' . I tried to replace single qoute in the filed name with chr(39) but no luck.
Is there any mistake in that expression?? Please help
Thanks in advance!!
Try to replace the outer single quotes with double quotes:
...Chart="Care Transitions (reporting Oct '14)",cou....
Kim,
Thanks for your reply
Unfortunately its a name of the particular record but not a field name. But I tried with double qoutations too and it didn't help
I'm not sure but in the set analysis try:
...[CAHPS Chart Domain]={"Care Transitions (reporting Oct '14"}...
or store the field name in a variable:
vFieldName = 'Care Transitions (reporting Oct ' & chr(39) & '14)'
and try:
...[CAHPS Chart Domain]={vFieldName}...
Azam
I can't find an actual error in the expression, but this workaround _should_ work (if the rest of the expression is OK:
if(Replace(DChart, chr(39), '') ='Care Transitions (reporting Oct 14)
But that will of course not work in the Set Analysis..