
1. Re: Conditional Field Calculation
raybaudi Nov 3, 2012 2:08 PM (in response to wrobinson)How do we specify in the calculation which should give a result as table 1 or table 2, since both depend on the same value of two fields?
BTW: for the left table, try:
Choose ( Field1&Field2 ;1;1;2;3;"";"";"";"";"";"";0;2;3;4;"";"";"";"";"";"";0;1;4;5;"";"";"";"";"";"";0;1;2;6 )
or
Middle ( "1123......0234......0145......0126" ; Field1&Field2 + 1 ; 1 )
or
Middle ( "1123023401450126" ; Div ( Field1&Field2 + 1 ; 10 ) * 4 + Mod ( Field1&Field2 + 1 ; 10 ) ; 1 )
and for the right table:
Choose ( Field1&Field2 ;0;4;6;8;"";"";"";"";"";"";1;2;6;8;"";"";"";"";"";"";1;3;4;8;"";"";"";"";"";"";1;3;5;6 )
or
Middle ( "0468......1268......1348......1356" ; Field1&Field2 + 1 ; 1 )
or
Middle ( "0468126813481356" ; Div ( Field1&Field2 + 1 ; 10 ) * 4 + Mod ( Field1&Field2 + 1 ; 10 ) ; 1 )

2. Re: Conditional Field Calculation
wrobinson Nov 3, 2012 2:52 PM (in response to wrobinson)The choose fields function works great!
Thank you so much!