Forum Discussion

MarkBird's avatar
MarkBird
Contributor III
2 years ago

Column override doesn't work when the name has spaces in it

Hi I am using a column override formula in my cube view and I have noticed that it doesn't work when I try override a column when the name has spaces in it, even if I surround it in square brackets...
Cube View
kenostrovsky's avatar
kenostrovsky
New Contributor III
2 years ago

The Column name that is displayed on the report is separate from the column name in the cube view designer. You should remove the spaces from the column names so that your column math works. You can specify the display column name in the formula for that column using the "Name" parameter. 

GetDataCell(CVC(SomeColumnName) - CVC(SomeOtherColumnName)):Name(Header Name)