linking two forumla with a comma

[ss7415]

i have a forumla, if one fields is blank i do not want to see a comma after, if both are populated i want to see a comma to seperate. how do i do that

{@display} +","+ {@display1}

with this there is a comma regardless

 

[thiagarr]

Hi,

You probably will need an if statement to achieve this. An example could be something like the following:

if {@Display} = "" then {@Display1}
else
{@Display}&","&{@Display1}

HTH

TR

 

[ss7415]

Thanks thiagarr