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.