GetCellvalue to sum using substitution variables

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

Thank you. It works fine only when you the columns explicitly have it the Cube Views.

In the first column which i have named as "Qtrs" have a time formula as "T#2021.Quarters" which in Data explorer expands and gives me all the quarters of 2021 (Q1, Q2, Q3, Q4). 

If i use your suggested formula in a new column, it gives only the data of Q1

Formula used - GetDataCell(CVC(T#2021.Quarters) + 1):Name(Sum)

I did try placing the column name between the CVC( ) - Screenshot attached. But again it gives me only the result of first quarter, rather than adding 4 quarters

Hi, 

Could this work? POV could also be CV depending on which year you want to substitute.

GetDataCell(T#|PovYear|Q1+T#|PovYear|Q2+T#|PovYear|Q3+T#|PovYear|Q4):Name(Total)