|
Group: Forum Members
Last Active: 9 Years Ago
Posts: 6,
Visits: 12
|
If I use the following =IF(LIKE(Fields!Symbol, "1tBRN"), Fields!closeval, 40 ) as a data value against the following data I get a nice chart:
date | Symbol | closeval | | Type | Text | Text | Double | | 04-12-2015 | 1tBRN | 57.86 | | | | | | 04-13-2015 | 1tBRN | 57.93 | | | | | | 04-14-2015 | 1tBRN | 58.43 |
|
If I use the dame formula against mixed data | | 04-12-2015 | 1tBRN | 57.86 | | 04-12-2015 | 1tWBS | 51.52 | | 04-13-2015 | 1tBRN | 57.93 | | 04-13-2015 | 1tWBS | 51.91 | | 04-14-2015 | 1tBRN | 58.43 | | 04-14-2015 | 1tWBS | 53.29 | | 04-15-2015 | 1tBRN | 60.32 |
|
| | | I get :
An error occured during the web part rendering. The error was: Pivot processing failed during: Phase: Processing Pivot - Data Matrix - Properties, Action: Evaluating - =IF(LIKE(Fields!Symbol, "1tWBS"), Fields!closeval, 45 ). Error was: Unable to cast object of type 'Nevron.FormulaEngine.NVariant[]' to type 'System.IConvertible'. |
|
|