Forum Discussion

Haaris_Uddin's avatar
Haaris_Uddin
New Contributor III
4 years ago

If Then Statement

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.

Cube View

6 Replies

  • TerryLedet's avatar
    TerryLedet
    New Contributor III
    4 years ago

    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

    • AndyR's avatar
      AndyR
      New Contributor III
      4 years ago

      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's avatar
        Mike_Sabourin
        Contributor II
        4 years ago

        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.

    • Haaris_Uddin's avatar
      Haaris_Uddin
      New Contributor III
      4 years ago

      Thanks Terry. Member formulas are something that I need to get much better at. https://onestreamchampions.influitive.com/forum/u/andy.renich will use “IsColumnVisible = CVMathOnly” for the column we are dividing. Appreciate it!