Finding Pending Docs

[jyothish8807]

Hi,

I was trying to create a field ,but got stuck with a particular condition,plz help me in that.

Scenario is something this.

Suppose a teacher is supposed to check 100 answer sheet in 5 Days. So his daily target will be 20 ( 100/5).

But if he checks only 18 on theday then on a Field Named "Pending" it should show "2"  and his next day target should automatically update to "22" instead of 20.

How can i create the pending field. it shuld keep on updating as per the dates i select. So, what i cant is my daily target shold automatically updated as per the date iam selecting.

Name	Actual Done	Daily target	weekly target	Pending
aaa	18	20	100	2
aaa	20	22	100	2
aaa	18	22	100	4
aaa	24	24	100	0

regards

Jyothish KC

[kaushiknsolanki]

Hi,

     Its better if you share sample data, to give us more clarification on what data you have.

Regards,

Kaushik Solanki

[#3]

use INPUTFIELD  for dynamically update the data.

syntax:

INPUTFIELD a;

load   a,

         b,

         c

from table;

then on pivote table, field a add as expression add clik on any data to modify the value.

then on this modification other fields automatically updated..

[#4]

Try this (see attached). I have used the above function

[jyothish8807]

Can you please explain this line:

if(len(20 - aggr(above(sum([Actual Done])),Name,RowNo)  + 20) = 0, 20, 20 - aggr(above(sum([Actual Done])),Name,RowNo)  + 20)

Regards

Jyothish KC