Expressions DataTable Syntax Error

Question

0.00/5 (No votes)

See more:

Can any one tell me what the syntax error is in the code below 
here i am trying to find minimum of two values 

cpK.Expression = "IIF((Convert(point50,'System.Double') - Convert(LSL,'System.Double')) < ((Convert(USL,'System.Double') - Convert(point50,'System.Double')), Convert(point50,'System.Double') - Convert(LSL,'System.Double'), Convert(USL,'System.Double') - Convert(point50,'System.Double'))/3.0/Sigma";

Posted 16-Mar-14 23:04pm

FarhanShariff

Add a Solution

Comments

Bernhard Hiller 17-Mar-14 11:12am

What's the type of cpk?
Why don't you do those conversions before - that expression in unreadable!

FarhanShariff 17-Mar-14 11:29am

Formula: Sigma = P90-P10/2.56 Cpk = Minimum|[ (P50 point - Lower) / 3 (sigma), (upper - P50 pint) / 3 (sigma)]|

DataColumn sigma = table1.Columns.Add("Sigma", typeof(double));
DataColumn cpK = table1.Columns.Add("CpK", typeof(double));

// set their expression properties
sigma.Expression = "Convert(point90,'System.Double') - Convert(point10,'System.Double')/2.56";

cpK.Expression = "IIF((Convert(point50,'System.Double') - Convert(LSL,'System.Double')) < ((Convert(USL,'System.Double') - Convert(point50,'System.Double')), Convert(point50,'System.Double') - Convert(LSL,'System.Double'), Convert(USL,'System.Double') - Convert(point50,'System.Double'))/3.0/Sigma";

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Bernhard Hiller · Answer 1 · 2014-03-17T05:38:00

/3.0/Sigma
is at the wrong position. You must apply it to both possible choices:
cpK.Expression = "IIF((Convert(point50,'System.Double') - Convert(LSL,'System.Double')) < ((Convert(USL,'System.Double') - Convert(point50,'System.Double')), (Convert(point50,'System.Double') - Convert(LSL,'System.Double'))/3.0/Sigma, (Convert(USL,'System.Double') - Convert(point50,'System.Double'))/3.0/Sigma)";

Expressions DataTable Syntax Error

1 solution

Solution 1

Add your solution here

Preview 0

Expressions DataTable Syntax Error

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us