AnsweredAssumed Answered

Calculation problem

Question asked by tays01s on Aug 31, 2017
Latest reply on Aug 31, 2017 by tays01s

I can't see what is probably a simple error in this:

If(

 

Get(RecordNumber) = 1; in_water_pc;

 

GetNthRecord (Ocome_cum_in_water_pc; Get( RecordNumber ) - 1 ) + in_water_pc

 

)

- (100 * Get(RecordNumber))

 

Both the If () component and "- (100 * Get(RecordNumber))" component compute correctly if separate. However, put together, after the 1st record, values become inaccurate.

Outcomes