I've been using a calculation meant to insert a number into a field after I "close off" a date in a schedule. The field has 10 repetitions. The formula works fine except for repetition 10, which is returning "0". BTW the "rep-1" is there because Choices are numbered 0,1,2 etc. and repetitions 1,2,3 etc. Ideas?
Let ( rep=Get ( CalculationRepetitionNumber );Case(GetRepetition ( CLOSED ; rep)="Closed";"-"&Count ( Choose ( rep-1 ; SN_SERVICE1::SUB_SH;SN_SERVICE2::SUB_SH;SN_SERVICE3::SUB_SH;SN_SERVICE4::SUB_SH;SN_SERVICE5::SUB_SH;SN_SERVICE6::SUB_SH;SN_SERVICE7::SUB_SH;SN_SERVICE8::SUB_SH;SN_SERVICE9::SUB_SH;SN_SERVICE10::SUB_SH) )&" -";"" ))