Formula Column - Cell Reference as opposed to Field Label Reference

Support
1

I have a subtable on my form where each row hold various values relating to a specific year.

Each row (year) needs to house formula columns which reference and use values from the previous years record. They in turn being used as part of the calculation in next years values.

Is this possible?

Thanks

2

Hi Scott,

Would you mind to try if PREVIOUSROW(value) works for you?
%E5%9C%96%E7%89%87

3

Hi Angie

I will give that a try!

Thank you

4

Hi Angie

That gives me the running balance for the column but I need to extract the previous rows value in that column.

Thanks

5

Hi Scott,

You can assign formula to minus that column from the retrieved running balance:

image

image

6

Hi Amy

Thank you. I need to keep calculating the last columns value so in the above example I’d need C7 to show 150. Is that possible?

7

Hi Scott,

To retrieve last value of the column from subtable, you can use LAST() formulas.

8

Hi Amy

Sorry, my bad terminology. That should have said ‘previous’ not ‘last’. In your example I need to see the previous value for B in the current row. So every row that is added looks up the previous rows value for B.

9

Hi Scott,

Please refer to my second reply with the example “PREVIOUSROW(B4)-B4”.

10

Hi Amy

As I mentioned in a previous reply that doesn’t work. See screenshot. C does not provide me with the previous Row value of B after the second row. I don’t want the running balance. Based on the screenshot the values for C should be 0, 100, 150, 200

Capture

11

Hi Scott,

Let me check with our developers and see if we have a function to support something like this.

12

Cheers Jeff