Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I try Code but it error
Are you looking to display Zero when SampleNo is blank? If so, try like below..
=WorkOrder&'-'&Alt(SampleNo,0)
If not, can you elaborate your requirement in detail?
Want WorkOrder&'-'&0 to divide WorkOrder into each WorkOrder.
for example WorkOrder&'-'&SampleNo
11111-0
11111-1
11111-5
11111-7
11111-8
22222-0
22222-1
22222-3
22222-5
33333-0
33333-1
33333-2
33333-3
but SampleNo not have Value '0'
Require WorkOrder&'-'&0 to split each next WorkOrder.
by value
WorkOrder&'-'&0 equals 0
Try like below
Load * Inline
[
Dim
1
2
];
Calculated Dim:
=if(Dim = 1, [WorkOrder] &'-'& SampleNo, [WorkOrder]&'-'&0)
Result
I think this is what you're looking for ...
=WorkOrder&'-'&num(SampleNo,'0#')
I would like
What are the input values? I.e. what are the values of WorkOrder and SampleNo for each of these rows?