AnsweredAssumed Answered

Is a Calculation thru repititions in multiple digits possible?

Question asked by tomperr on Sep 1, 2017
Latest reply on Sep 1, 2017 by tomperr

I have a date field with calculation set up.  This is used as date for Gantt charting a schedule.

The way it works is "zv__startDate__gd" upon opening returns a date - 7, which is the start of the schedule.

The field that requires the change is set up as:

"Extend ( zv__startDate__gd ) + (Get(CalculationRepetitionNumber) + 7) - 1"

This works splendidly if I want to track every day's activities.  Instead I would like to have it generate a weekly schedule.

So if it generated a date from 9/1, the following dates would be 2, 3, 4 etc.

I would like the repetitions to return 1, 8, 15 etc.

How can this be done, if possible?

Outcomes