Skip to main content
H
Haaris_Uddin
Newcomer
January 12, 2022

If Then Statement

  • January 12, 2022
  • 1 reply
  • 0 views

SOURCE: ONESTREAM CHAMPIONS

Hi,

We are looking to take the values of a specific column and divide everything in it by 3. Was hoping to accomplish this via a Column Override. In the Cell Format within the column override we have tried several variations of the following without any luck:

If (CellAmount > 1) Then /3

EndIf

Thanks for your help.

1 reply

T
TerryLedet
Newcomer
January 12, 2022

Haaris

My suggestion would be to create a member with a member formula which is typically done in the UD8 dimension. In the member formula, you can create a variable for the cell amount defined as needed and then based on the value in the variable create the If Then logic which would be similar to your example.

Terry

A
AndyR
Newcomer
January 12, 2022

Hi Haaris,
Without knowing everything you’re trying to do, where I would start would be to use the column Header Format of: IsColumnVisible = CVMathOnly for the column you’re wanting to divide. Then create a second column and use a GetDataCell or something like that with the math you want to apply to the other column. Hopefully that helps.
Thanks, Andy

Mike_Sabourin
Mike_Sabourin
Contributor
January 12, 2022

You can just use GetDataCell math to accomplish this and suppress zeroes. I added a column to a cube view and did GetDataCell(Divide(CVC(CurrMos), 3)):Name( Div by 3) where CurrMos is the first column in my cube view.

Terms & ConditionsAccessibility statement