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 ?

Tks
AXISHKAsked:
Who is Participating?
 
TJCombosCommented:
You can use a macro to loop each cell and store the result at final cell
http://www.ehow.com/how_4471478_loop-excel.html
0
 
AXISHKAuthor Commented:
I would prefer to put in the calculated cell such that user could use that field in different worksheet....

Tks
0
 
mlmccCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
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.