Skip to Content
0
May 15, 2018 at 05:48 PM

Custom measure to get correct beginning head count for each quarter and year

964 Views

Hi,

We are BPC 10.1. We have below two statistical accounts in HR model.

1. Beginning HC - Stores beginning head count of the period

2. Ending HC - Stores ending head count of the period

Account Type for both the accounts is 'AST'

When we build a report to get Beginning HC and Ending HC by quarter, Beginning HC of third period of the quarter is shown as the beginning HC of the quarter. Our requirement is to show beginning HC of period 1 of the quarter as beginning HC of quarter.

Similarly, beginning HC of January to show as beginning HC of total fiscal year.

Check the example below. Can anybody provide a solution for this requirement.

Thanks,

Sampath.

Attachments

example.png (9.7 kB)