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
SKVK's avatar
SKVK
New Contributor III

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)

 

 

NidhiMangtani's avatar
NidhiMangtani
Contributor III
3 years ago

Please use column name in the CVC

GetDataCell(CVC(Qtrs) + 1):Name(Sum)

Thanks