AnsweredAssumed Answered

Help - Results of formula works for a number of lines and then corrupts

Question asked by MichaelShea_1 on Jan 10, 2015
Latest reply on Jan 18, 2015 by MichaelShea_1

Title

Help - Results of formula works for a number of lines and then corrupts

Post

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!

Formula:

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 ))

 

Thank youu

Screen_Shot_2015-01-10_at_8.26.12_AM.png

Outcomes