Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey Members,
i would like to show in the subtitle of a table, which Cost_Element are not included.
In the data editor i have two tables (mapping with Cost_Element):
1) Fact Table: Cost_Element and other informations
2) Mapping Table: Cost_Element and Kostenart1 and Kostenart2
Now the formula should give me the Cost_Element's which have no data in Kostenart1.
Formula like the following are not working:
If(Count(Distinct Cost_Element) - Count( {<Kostenart1 = {"*"}>}Distinct Cost_Element)>0, Cost_Element)
If(IsNull(Kostenart1),Cost_Element)
....
Can someone help me please?
Thanks and regards
surtex
Hello, would you like to have a formula that shows you the Cost_Element when Kostenart1 is null? IF this is the case you can use this formula.
if(len(Kostenart1 )<>0,Cost_Element )
Yeah i would like to show the Cost_Elements, which have no data in Kostenart1 but your formula doesn't work for me. Additional information: Table 2 (Mapping Table) has 125 Cost Elements which have all data in Kostenart1. Table 1 (Fact Table) has 128 Cost Elements. The tables are mapping about the keyword Cost_Element. So I should have 3 Cost Elements displayed..
I guess this won't work for you either?
if(len(Kostenart1 )=0,Cost_Element )
Otherwise you can take inspiration from this code to create a Flag allowing you to know if there is a Kostenart1 linked.