Skip to Content
0
Former Member
Sep 19, 2008 at 09:42 AM

Returned records different in query to workbook

24 Views

We are using Bex Analyser version 7.

I have a pending invoices query embedded in a workbook. If I refresh the query within the workbook, I get 3 fewer records than if I run the same query on its own.

When I identified the 3 invoices concerned I could see that they have a zero key figure values. I haven't suppressed zero records in the query but they appear to be suppressed in the workbook.

Has anybody got any suggestions for amending my workbook so that I get all the records?

Many thanks,

Positive Parrot