Create a calculated field in 2008 Analysis Services

I want to create a calculated field in Analysis Servcies with to combine 10 ACCOUNT SEGMENT. The last few segments may contain NULL VALUES.

How to create a string with format XXXX-XXXX-XXXX... such that those NULL segment will not be concatenated ?

Who is Participating?
You can use a macro to loop each cell and store the result at final cell
AXISHKAuthor Commented:
I would prefer to put in the calculated cell such that user could use that field in different worksheet....

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.