Skip to Content
Sep 04, 2020 at 12:52 PM

Cannot exclude unassigned values when using two different dimensions



I'm using SAP Analytics Cloud for planning and have trouble with a formula in a model. I have a scenario where I'd like to be able to add number of employees by Staff and Workers. Then I also like to add how these values should be distributed to different organizational units. Like this example with three different tables:

It is three organization units and a generic dimension named "Type" with "Staff" and "Workers". I have three accounts "FTE", "Split" and "Personnel"

The formula in Personnel account is:
RESULTLOOKUP([FTE],[d/Org]="#") * RESULTLOOKUP([Split],[d/Type]="#")

The problem I have is that I don't want to show unassigned values in the third table. But when I exclude unassigned values for the dimensions Type and Org all values in the third table disappears.

Please help.



nvvfe.png (35.0 kB)