[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 281
  • Last Modified:

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
0
AXISHK
Asked:
AXISHK
1 Solution
 
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now