To calculate weeks

[Ronal_bal]

Hi,

I need to calculate the weeks as in Date from the sequence of days field. 

I need to start from week-1 and end at week-10.

I need to repeat the process again whenever the week is 1 and stop at week 10. I need to repeat this process again and again,

FYI, the dataset has only has records containing week-1 to week-10 for each sample. not more than week-10 at any scenario.

I'm trying to do with multi-row formula. Is there any help?

Example attached,

[IraWatt · Accepted solution]

Hey @Ronal_bal,

Heres an example of how to do this:

The formula is:

IF [Sequence of days] = "week-1" THEN [Date] ELSE DateTimeAdd([Row-1:Output],7,"days") ENDIF

Any questions or issues please ask :)
HTH!
Ira

[michelle_mathews]

Hi @Ronal_bal - here's how I'd solve for your problem