AnsweredAssumed Answered

Total Portal Row calculation, but not the whole row from top to bottom....only from where it is...

Question asked by TaukoririMeita on Aug 6, 2013
Latest reply on Aug 12, 2013 by TaukoririMeita

Title

Total Portal Row calculation, but not the whole row from top to bottom....only from where it is needed.

Post


     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.

     Thanks.

sample.png

Outcomes