Calculated column in Data View RRS feed

  • Question

  • I am trying to create an analysis services cube but am having trouble with a calculated column in the data view.

    I have a fact table with three columns, say a,b,c , and only one of them will have a value in at a time. I want a calculated column that is populated by whichever of the three columns has a value in it.

    How can I do this in a calculated column expression?


    Many thanks.

    Thursday, June 16, 2011 2:45 PM