Help - Results of formula works for a number of lines and then corrupts
I am running a formula that calculates a cumulative inflation factor, by looking at the current period inflation (in one column), and multiplying it by the cumulative factor from the previous period in the calculation column.
The results are correct for a number of rows....and then corrupts and eventually gives a "?" response.
Makes no sense? Help!
If(FM Tab 1::Indice de Correcao = "Nao";1; (1+Correcao por mes Corrente)*GetNthRecord ( Correcao Acumulado _ a aplicar na Parcela do Mes ; Get(RecordNumber)-1 ))