Returned records different in query to workbook
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?