Forum Discussion

SKVK's avatar
SKVK
New Contributor III
3 years ago

GetCellvalue to sum using substitution variables

Team Is there a way where i can sum the columns/data using Variables.  Example: Instead of using GetDataCell(T#2021M1+T#2021M2):Name(Total) , can i use some kind of variable which calculates base...
Cube View
NidhiMangtani's avatar
NidhiMangtani
Contributor III
3 years ago

Hello,

Please explore using CVC on your cube view columns:

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

 

GetDataCell(CVC(Col1) - CVC(Col2)):Name(Variance)
Examples of Column Math:
GetDataCell(CVC(Col1) + 1):Name(Column Plus One)
GetDataCell(CVC(Col1) * (-1)):Name(Column with Sign Flipped)

Hope this helps.

Thanks