I am hoping someone might be able to help. I am using the list and MiddleValues functions to return selected values in a checkbox set of about 20 items of which only 12 can be selected
what i am trying to do is return the results into 3 columns of 4 purely for space purposes on a layout.
I tried MiddleValues (List ( Job Type ) ; 1 ; 4 ) as 1 calculated field then as the 2nd calculated field MiddleValues (List ( Job Type ) ; 5 ; 8 ) and third calculated field as MiddleValues (List ( Job Type ) ; 9 ; 12 ) however this returns the first 4, then next 6 and then 2 for the final calculation. I am not sure if i am using this correctly or if there is another method to achieve what i want.
Thanks in Advance