Forum Discussion

bisenhart's avatar
bisenhart
New Contributor II
5 months ago

Cube view formula

Hi there - Im looking to add a formula to my columns located in the cube view. I need it to pull global time + remaining target months. This involves two scenarios, so S#Actual and S#Target_FY24.    ...
Cube View
db_pdx's avatar
db_pdx
Valued Contributor
5 months ago

This can also be done with member expansions and a basic GetDataCell.

I'd recommend putting your global time in the fixed pov (|GlobalTime|) and then referencing that in your report. The GetDataCell would be:

GetDataCell(T#|CVTime|:S#Actual:V#YTD + T#|CVTime|:S#Target_FY24:V#RestOfYear):Name(Total)

Cheers,  -db