change the value for an ID

[Guest]

Okay here goes!

My boss wants a modification for a particular budget center. There is a
report that is generated by choosing the budget center and the return value
gives the summary of all the employees and their worked hours under this
budget center. The problem is the calculation created is for adding the
total for the month and divide it by a 40 hour work week example:
=sum(Oct/getweekdayhoursinmonth), this calculation is based upon 8 hours a
day, which is fine- except for the employees in India - which it should be
based upon a 9 hour day. The calculation was created in the report. What
method can I use to create filter, command, argument, etc. to change the
calculation for the budget center for India?
Someone. please help me!

 

[John Vinson]

Okay here goes!

My boss wants a modification for a particular budget center. There is a
report that is generated by choosing the budget center and the return value
gives the summary of all the employees and their worked hours under this
budget center. The problem is the calculation created is for adding the
total for the month and divide it by a 40 hour work week example:
=sum(Oct/getweekdayhoursinmonth), this calculation is based upon 8 hours a
day, which is fine- except for the employees in India - which it should be
based upon a 9 hour day. The calculation was created in the report. What
method can I use to create filter, command, argument, etc. to change the
calculation for the budget center for India?
Someone. please help me!

You may need another table. Right now you have only two workweeks -
what if you get business in France and need 32 hours, and then Japan
and need 80 <g>?

A table with country code and that country's work week would let you
calculate each country's data based on its work week; and there would
be no need to embed that information in hard-to-edit code, it'd be
right in an editable table.

John W. Vinson[MVP]

 

[Guest]

Further information
what happens is the user chooses the budget center and year(2006) - the
report then generates all of the employees under that budget center - certain
budget centers include employees in India. The design created for the report
has a calculation based upon the total sum of workers, divided by a total
hours in that particular month. The calculation is in the design of the
report - it adds the total sum for that month and then divides by the total
hours worked in month(40 hr per week)base. This existing report doesn't read
or filter India employees.
what can I do to change this calculation
example: budget_center: 3105 under this budget center are resources for
India and US employees - it returns a number value.
resource: pm = 115
resource: superv=206, etc the number value is then entered for the month of
October as total 321 divided by 160=.

 

[John Vinson]

Further information
what happens is the user chooses the budget center and year(2006) - the
report then generates all of the employees under that budget center - certain
budget centers include employees in India. The design created for the report
has a calculation based upon the total sum of workers, divided by a total
hours in that particular month. The calculation is in the design of the
report - it adds the total sum for that month and then divides by the total
hours worked in month(40 hr per week)base. This existing report doesn't read
or filter India employees.
what can I do to change this calculation
example: budget_center: 3105 under this budget center are resources for
India and US employees - it returns a number value.
resource: pm = 115
resource: superv=206, etc the number value is then entered for the month of
October as total 321 divided by 160=.

I have NO idea how you would do this.

The information as to which hours should be calculated on a 40 hour
week, and which on a 50 hour week, needs to be stored *somewhere*.
Nothing in what you've posted gives any indication how this can be
done. If you don't "read or filter India employees" then there's no
way, even in principle, to treat Indian employees differently than
North American ones.

John W. Vinson[MVP]