How to fix the week target values

[Suresh_Murugan]

Dears,

How to fix the weekly target values.

My query: 5468 records. target date 27-Apr-2017.
week starting day Saturday. How to fix the value of first day of week until last day of the week.

Please help......

 

[sneuberg]

I don't understand what you want to do. Do you want to change the records with the date 27-Apr-2017 to some other date?

How to fix the value of first day of week until last day of the week.

What you your mean by "fix"? Set or repair? And where do you want to do this?

 

[Suresh_Murugan]

Thanks for your reply.

we are updating daily progress as per completion of site work basis.

i.e: Week starting day saturday remaining items 750 qty. target of completion date 27-Apr-2017. Round of 9 weeks target completed this qty. But we are divided this qty in 9 weeks. 1 week of target 84. This value we want fix one week. How many completed one week below 84 that will be increase next week, above 84 complete will be reduce total value.

I want how to we fix 84 one week.

My query: TDays: DateDiff("d",Now(),[Target_Date])
TWeek: Round([TDays]/7,0)
Target: Round([BStatus]/[TWeek],0).

This value change complete basis. I want weekly target fix. (one week target)


please refer attached 2 days report snapshot. There is week target changed daily completed progress.