Advanced function subquery in master query (bug?)
I have a subquery and a master query. In my subquery I have calculated the Delta of price. In my master query I have made a calculated field called Copy of delta of price (see below, sorry it's in Dutch) where I want to see my subquery Delta of price so I can use it for another calculated field Price rise and Price drop.
However, as you can see below my calculated field (Copy of delta of price) in my master query simply shows the Price and not the advanced function I have used on it. What is going on here? (Bug?)
All help is really appreciated, really enjoy the BI tool so far. Hope my situation and the question is clear.