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

AndyR's avatar
AndyR
New Contributor III
4 years ago

Hi Haaris,
As you’re learning what’s possible and how to do it, I’d suggest a good way to do that is by opening the Member Filter Builder (the ellipsis at the end of the Member Filter field) and look at the Samples tab. There is a lot of information you can gather from those. For this specific issue, you can see the syntax under Column/Row Expressions.