So that did SOMETHING, but it numbered the weeks all weird, starting with 4 then jumping to 11 ... please see picture attached ... it looks like it split it into the right portions, but it didnt label them in sequential order?
this is the expression i used in the load script
Autonumber( Weekstart([Close Date]), CloseQuarter) as OppCloseQuarterWeekNumber
If you will have to create a new resident load for the purposes of creating just this new field, then you might see some performance loss. But if you already have a resident load, then performance might not go down drastically.
yes, your dates need to be sorted chronological (at least per quarter) to make this work, since the Autonumber() just assigns incremented integers per new expression result / calculated symbol (first argument) (and per quarter, second argument).
I assumed you were using a master calendar, and these are usually created using a loop, creating dates in correct order: