Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a document bookmark with a list of product numbers in it. I am using that bookmark with set analysis. This works fine in the corporate version, but when I use publisher to provide reduced dataset versions for the field and those reduced versions of the dataset do not have any of the product numbers associated with my bookmark in their datasets then the bookmark does not find any of the products and I get a full set of data in my calculation.
My expression is: sum({$ * BM29} [Extended Price]) I am expecting a result of zero when there are no products found in the reduced set; however, I am getting the sum of extended price for all products instead. Any ideas on how to get this to work?
I'm not sure, but maybe you could try
sum({BM29} [Extended Price])
instead?