AnsweredAssumed Answered

Calculation Snag

Question asked by RickWhitelaw on Apr 13, 2009
Latest reply on Apr 13, 2009 by RickWhitelaw

Title

Calculation Snag

Post

Hi,

 

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) )&" -";"" ))

 

RW 

Outcomes