I want add Value '0' to SampleNo .

[Sxbbb]

I use code

result

This is Field SampleNo 

I want add Value '0' to SampleNo and 

Bring workoder to connect SampleNo which has added 0 .

I use the code but it gives error.

[Sxbbb]

but always want to add WorkOrder&'-'&0 =0 .

[Sxbbb]

WorkOrder&'-'&SampleNo always has a value in field = MeasurementValue .

[Sxbbb]

I use Code 

=if(Dim = 1,[WorkOrder] &'-'& SampleNo, [WorkOrder]&'-'&0)

Result 

I want each MeasurementValue of MeasurementNo of [WorkOrder]&'-'&0 to be equal to 0.

Want a value equal to 0

[MayilVahanan]

Hi

Measure would be

=if(Dim = 1, ur original measure, 0)

[Sxbbb]

The resulting value of [WorkOrder]&'-'&0.

MeasurementNo1 use code 

But the value [WorkOrder] &'-'& SampleNo came out correct.

Want [WorkOrder]&'-'&0 value came out correct

[Sxbbb]

I did it, thank you very much everyone.

[Sxbbb]

But I have used it to make Line Chart. 

The value of [WorkOrder]&'-'&0 equals 0.

Why doesn't the line descend to 0?

[Sxbbb]

I Sort the chart, why not in ascending order?

should be sorted

A0172434-01-0

A0172434-01-1

A0172434-01-2

A0172434-01-3

A0172434-01-4

A0172434-01-5

A0172434-01-6