hi all, I am trying to combine two fields in a gridfield to one. Basically

hi all,
I am trying to combine two fields in a gridfield to one. Basically I am trying to combine firstname and lastname into a common field called "name". so what I did was create an expression rule which does the following:

ri!firstname & " " &ri!lastName.

the in the grid rule I did the following:
a!gridtextcolumn(
data: {apply(rule!expressionRule, index(local!datasubset.data, "firstname", {}), index(local!datasubset.data, "lastname", {}))}
)

but the output I am getting for lets say a name called "john smith" is the following:
John Smith Smith Smith Smith
John Smith Smith Smith Smith
John Smith Smith Smith Smith

anybody have any idea what to do?...

OriginalPostID-111527

OriginalPostID-111527