Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Calculated Dimension in a Pivot Table with some characters which may be interpreted as special characters. I suspect that this is the cause for the 'error in calculated dimension' which i get.
Characters include '/', '.', '&', '(', ')'. Which characters are indeed special characters, and how to make them been considered as normal characters ?
Thanks in advance
Use chr(nnn) for special carachers
thanks. that is to say chr(\), chr(&), etc... ?
Additionally, there is a quote character ' inside a string. How to make it considered as a character in the string ?
thanks in advance
Use CHR() function in the calculated dimension
Ex:-
Chr(92) and Chr(38) in the calculated expression
Have a look at this example using CHR(39) instead of '
do i simply replace in the string the character by chr(xx) or what is the syntax ?
Thanks for your help
Replace the special character such as ' with the corresponding CHR() i.e. CHR(39) is equal to '
Use Replace function with the Chr() function and use that Chr value to replace
I cannot open the file in the Personal Edition. Would you accept to reproduce the expression here ?
Thanks