Profile Picture

String Was Not Recognized as a Valid Boolean

Posted By John Keadle 13 Years Ago
Author
Message
John Keadle
Posted 13 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: Forum Members
Last Active: 13 Years Ago
Posts: 1, Visits: 1

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



Nevron Support
Posted 13 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)

Group: Forum Members
Last Active: Last Year
Posts: 3,039, Visits: 3,746

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.



Best Regards,
Nevron Support Team





Similar Topics


Reading This Topic