> For the complete documentation index, see [llms.txt](https://docs.pentaho.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.pentaho.com/pba/10.2-analytics/pentaho-analyzer-cp/set-analyzer-report-options/working-with-rows-where-the-number-cell-is-blank-analyzer-report-options/what-happens-when-there-is-no-number-field-on-the-report-analyzer-report-options.md).

# What happens when there is no number field on the report?

The following rules apply:

* If there is only one text field, such as 'Product Line', but no number field on the report, then all values will be displayed. For example, all product lines will be displayed, even those that did not have data.
* If there is more than one text field, such as 'Product Line' and 'Region', but no number field on the report, then the report will hide some values when showing rows or columns with measure and/or calculated measure data. You should not draw any conclusions from the report in this state. Instead, add a number field.

The rules above are designed to minimize the confusion which may result if an expected value does not appear, but you should also consider usability and performance when displaying every single combination of data elements.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.pentaho.com/pba/10.2-analytics/pentaho-analyzer-cp/set-analyzer-report-options/working-with-rows-where-the-number-cell-is-blank-analyzer-report-options/what-happens-when-there-is-no-number-field-on-the-report-analyzer-report-options.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.