06-16-2014 12:05 PM
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.
What formula can I use to copy Quarter 1 targets to Quarter 2 targets
06-16-2014 12:08 PM
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.