The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
Cube View Cell Conditional Formatting - Large % result
I am trying to create a conditional formatting code to convert a large percentage result in a percent variance column to replace it with text ("nm"). Can anyone provide the conditional formatting text that would replace the actual % variance with text?
This is our |!Percentage_Cell!| parameter:
Scale=0, ExcelUseScale = True,
If (CellAmount >= 10) Then
ExcelNumberFormat = ["NA";"NA";"NA"], NumberFormat = ["NA";"NA";"NA"]
Else If (CellAmount <= -10) Then
ExcelNumberFormat = ["NA";"NA";"NA"], NumberFormat = ["NA";"NA";"NA"]
Else
NumberFormat = [#,###,0.0%], ExcelNumberFormat = [#,###,0.0%]
End IfFor anything greater than +/-1000% (10), we replace the value with 'NA'. Apply to your row/column cell format as applicable.
2 Replies
This is our |!Percentage_Cell!| parameter:
Scale=0, ExcelUseScale = True,
If (CellAmount >= 10) Then
ExcelNumberFormat = ["NA";"NA";"NA"], NumberFormat = ["NA";"NA";"NA"]
Else If (CellAmount <= -10) Then
ExcelNumberFormat = ["NA";"NA";"NA"], NumberFormat = ["NA";"NA";"NA"]
Else
NumberFormat = [#,###,0.0%], ExcelNumberFormat = [#,###,0.0%]
End IfFor anything greater than +/-1000% (10), we replace the value with 'NA'. Apply to your row/column cell format as applicable.
Thank you so much! That worked perfectly.
