AnsweredAssumed Answered

Want a proper running  balance

Question asked by ShaikhAtta1238 on Jan 18, 2012
Latest reply on Jan 19, 2012 by philmodjunk

Title

Want a proper running  balance

Post

Hello and thanks in advance!

 

I want a proper running balance, this is what i want, actually i am running a simple (Balance = Target-Target Achieved) formula which updates the values in all the workplans as the same which was given in the last record. For example The March 2012 workplan target records are showing in the January 2012, although this is not what i want.

 

January 2012

Activity-----------Target--------Target Achieved----------Balance

Rugby              10                2                                   8

Soccer              20                5                                   15

Baseball           12                3                                  9

 

Feburary 2012

Activity-----------Target--------Target Achieved----------Balance

Rugby              8                2                                   6

Soccer              15               5                                  10

Baseball           9                3                                   6

 

March 2012

Activity-----------Target--------Target Achieved----------Balance

Rugby              6                   1                                   5

Soccer              10                  2                                  8

Baseball           6                    2                                  4

 

 

Hope fully you got my point. 

Outcomes