Value from wrong version is returned
I have a problem where I get value summed by a wrong version returned.
From a module without any versions, I want to pick up FTE values from budget version in another module which has versions and sum by which role the employee has.
The formula looks like this:
'FTE Module'.'FTE'[SUM: 'FTE Module'.'HR-Role', SELECT: VERSIONS.Budget]
The formula above returns the correct FTE value but sums by the HR-role that was entered in Forecast version (which is set as current version if that could be important information).
Any suggestions why this happens?
Description of attached filescreen dumps:
pic1: Blueprint of the module in which I want to present budget FTE data summed by HR-Role.
pic2: Blueprint of the module from which FTE data is collected.
pic3: Presents the data of my test person, which is the data I want to collect. As you can see he's set to HR-Role "Admin local" in Budget version (and "Consultants local" in Forecast version). FTE value is set to 1 for budget version and 0 for forecast version. (Blueprint of module in pic2)
pic4: Result of how data was collected (module blueprint in pic1). As you can see, the FTE value is correct but person (which is the only person under list item "610 - sweden") gets HR-Role for forecast version instead of budget version.
Clarification: list O5-department roster and list O4-PC in described modules are hierarchical lists.