I have data sheet of employee hours breakup on weekly basis (typically considered as 40 hours per week) and I need to publish a report on Monthly hours.
Some of the week are split between 2 months, for example Week starting 29 Jun 2020 week has 2 Working days in Jun and 3 working days in July. This week need to split up as 2 working days in Jun & 3 days in July.
Any Suggestions of how this need to be done ?
Do you still need assistance with this question? If so, would you be able to share a sample workbook? See instructions for creating a packaged workbook
A quick method to anonymize a workbook is to hide any fields containing sensitive information before the data source is extracted. Hidden fields are not included in the final extract.
Solutions often have to be customized for the structure of the data and how the final view is built, therefore a sample workbook is helpful.
:) What do you think of the new Community Forums? Let us know!
