0 Replies Latest reply on Oct 20, 2013 7:10 AM by shae1725

# Help with a Calculation

### Title

Help with a Calculation

### Post

Let (
L = List ( A ; B ; C ;D ) ;
Case (
IsEmpty ( Self ) ; Get ( ActiveFieldContents ) ;
Self
)
)

I have this calculation already in fields A;B;C;D  used to populate the four fields if empty.

I want to be able to add more features but not sure how!

I need to add the following calculation

Record 2    =   Record 1 -  FieldX(Record2)

Record 3   = Record 1  - ((FieldX(Record2) + FieldX(Record3))

Record 4    =  Record 1 - ((FieldX(Record2) + FieldX(Record3) +FieldX(Record3))

etc etc

(will ever only be approx  2 - 10 records)

ie

Record 1       fieldA (100)     fieldB(100)      fieldC (100)      fieldD (100)    fieldX (will always be empty)

Record 2       fieldA (90)        fieldB(90)       fieldC (90)        fieldD (90)      fieldX (10)

Record 3       fieldA (85)        fieldB(85)      fieldC (85)        fieldD (85)       fieldX (5)

Record 4       fieldA (70)        fieldB(70)      fieldC (70)        fieldD (70)       fieldX (15)