ContributionsMost RecentMost LikesSolutionsFormula to retrieve Application Property such as Global Time Is there a formula (for use in Excel/Spreadsheet) to retrieve the Global Time setting from Application Properties? Re: How to grab Prior 6 months in CV Instead of |CVTime| try your |WFTime| as I'm guessing your Cube View POV is set to 2016 while WF POV is set to 2021 Re: Formula to retrieve Application Property such as Global Time I think I found answer? Just put "Global" as the Time member in the XFGetCell formula? Re: How to grab Prior 6 months in CV Also, for a total column X number of periods back, take a look at the ViewXXMonthTotal, like in example below "Trailing T#WF:V#Trailing12MonthTotal:Name("LTM") Re: How to grab Prior 6 months in CV Hi - Try the using this as your column member filter: T#Year(|CVTime|)PeriodPrior5(|CVTime|), adjusting the number after prior period to the appropriate number of months prior
