AnsweredAssumed Answered

Help with a Calculation

Question asked by shae1725 on Oct 20, 2013

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)

      

      

Outcomes