Filter by IF and Like?

Nevron Forum

Back

Filter by IF and Like?

Author

Message

Jonathan Green

posted 10 Years Ago

Group: Forum Members
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

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

date	Symbol	closeval
Type	Text	Text	Double
	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'.