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 wi...
Cube View
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 Michel!! That worked.