Thanks for your help in this. As a workaround, we have decided to go with the transform function on the data pill.