Total Portal Row calculation, but not the whole row from top to bottom....only from where it is needed.
So I've uploaded an image so you can better understand what I'm trying to accomplish. Two related Tables, Table1 has Field1 and Table2 has Field2 in a portal row.
Field1 is = Leave Days taken this year
Field2 is = Total No of Days taken
I want Field1 to show the Total of Field2 easy as SUM ( Table2::Field2 ) which only works if you want the total of the row from top to bottom. But I only want it to total up from where I want it. For example check this year and refer to the portal then calculate the total of Field2 for this year only. And since Field2 will continue to change, I want Field1 to auto update with it.
I know it must be difficult to understand what I'm trying to say here but maybe if you take a look at the picture below you'll get my point.