This content has been marked as final. Show 2 replies
See attached QVW
Notice this load script, which will implicitly JOIN on the "Top Level Line" column.
LOAD * INLINE [ Top Level Line, Value Other Income, 10 Revenue, 5 ]; LOAD * INLINE [ Top Level Line, Detail Line, DetailValue Other Income, Misc Income, 1 Other Income, Minor Income, 3 Other Income, Special Income, 6 ];
I want to identify Top Level Lines that have some extra detail.
In other words, Top Level Line where COUNT([Detail Line])>0
I've used that expression in 3 places.
Why does the first use fail?