Forum Discussion

AndreaF's avatar
AndreaF
Contributor III
3 years ago

Dynamically calculate YTD average

Hi, I've build an dynamically calculated account that should show the FTE YTD average, so that if the month is February it returns the average FTE of the Jan and Feb, if the month is March it return...
Metadata
  • AndreaF's avatar
    AndreaF
    3 years ago

    I have just noticed I can use the YearAvgToDate member from the View dimension to return the average. The members seems to work fine with balance accounts too!

    Now my formula is much much simpler:
    'Return the YTD average of the FTE account
    Return api.Data.GetDataCell("A#PP_Acc_FTE:V#YearAvgToDate")
AndreaF's avatar
AndreaF
Contributor III
3 years ago

I have just noticed I can use the YearAvgToDate member from the View dimension to return the average. The members seems to work fine with balance accounts too!

Now my formula is much much simpler:
'Return the YTD average of the FTE account
Return api.Data.GetDataCell("A#PP_Acc_FTE:V#YearAvgToDate")