How to pull the annual total from the month forecast module?

Much appreciate if someone can help with this one.

Source module: monthly expense

list: cost center & expense type

Dimension: time (by month, with year total FY23); version (actual & forecast)

Line item: expense

Target module: Annual summary

list: cost center & expense type

Line item: expense, budget, variance, %


Question: what is the correct formula for target module line item 'Expense'?


  1. TIMESUM(Source.Expense, TIME.'FY23'),
  2. SUM(Source.Expense, Source.Time.'FY23')
  3. Source.Expense[SELECT: TIME.'FY23']

None of them were working.

Best Answer

  • gaurav
    Answer ✓

    Hi @Mili your formula is not working because of Version. Which version you want to pull in target? Actual or Forecast? or the sum of both? If you want to pull Actual, use this formula:

    Source.Expense[SELECT: TIME.'FY23', SELECT: VERSIONS.Actual]

    Or else if you want to get the sum of Actual and Forecast then create a new version to aggregate the Actual and Forecast Versions