Forum Discussion

johnal67's avatar
johnal67
Contributor
2 years ago

Conditional Formatting on BWPercent column

I have the following column member filter.  S#Actual, S#Budget3, S#Actual:T#YearPrior1(|!Param_Time_Select!|)Period(|!Param_Time_Select!|), GetDataCell(BWDiff(S#Actual, S#Budget3)):Name(BW Diff), Ge...
Cube View
  • MikeG's avatar
    MikeG
    2 years ago

    Hi johnal67 , each comma creates a new Column in your Cube View.  Making it difficult to isolate the one instance and format for BWPercent.  The quickest way to accomplish this would be to break out those in to separate columns.

    In this case you can isolate the VarPct column definition and format it as a % for display. 

    Hope this helps.

     

MikeG's avatar
MikeG
Contributor III

Hi johnal67 , each comma creates a new Column in your Cube View.  Making it difficult to isolate the one instance and format for BWPercent.  The quickest way to accomplish this would be to break out those in to separate columns.

In this case you can isolate the VarPct column definition and format it as a % for display. 

Hope this helps.

 

johnal67's avatar
johnal67
Contributor
2 years ago

That's what I was afraid of I was hoping I was missing something.  I thought I was doing good to not break them up into columns, but your confirmation helps to go forward with doing that.  Thanks!