I'm running the configuration for a readial guage.

I'm connected to a SharePoint list with 24 items. I can connect and preview my data.

Each item has a column called "Value" and I want my pointer to point to the sum of the column values.

On the Guage | Guage Areas | Pointers | General tab, I'm using the formula:

     =SUM(Fields!Actual_Value)

When I try to preview, I get:

     Gauge Preview Failed: Pivot processing failed during: Phase: Processing Pivot - Filtering. Error was: String was not recognized as a valid Boolean.

What string am I missing?

JK

Hello John,

The error message states that you have a filter which is incorrect. It looks like the expression you have for your filter is not returning True or False but it returnes a string.

Based on your requirements, "I want my pointer to point to the sum of the column values", we are not sure if you require any filters in your Pivot configuration. You can try removing the filter.