StM Aggregates and Targets

Reply
Learner
Posts: 1

StM Aggregates and Targets

Aggregates:

Hi can someone help me figure out the formula to aggregate a specific quarter, e.g. Quarter 2 is empty, 1 and 3 have values, so I need to find the aggregate for Q2.

Targets:

What formula can I use to copy Quarter 1 targets to Quarter 2 targets

Regards

FLASH

Super User
Posts: 17,784

Re: StM Aggregates and Targets

Without knowing what your data looks like, we can't help very much. Its best to post a sample of your data and the output expected.

For Targets, look at the Retain and/or Lag functions.

Ask a Question
Discussion stats
  • 1 reply
  • 184 views
  • 0 likes
  • 2 in conversation