Formula concatenating multiple values

[Alamelu]

Hi
I have been trying a formula as follows:

if {@sub+cat}=next({@sub+cat}) then
if {@sem} <> next({@sem}) then
{@sem}+', '+next({@sem}) else
{@sem}

This formula works fine @sub+cat has two corresponding values of @sem. In some cases this exceed more than 2 values. The report is sorted by {@sub+cat. Can somebody help me with the formula?

 

[FoxG]

Hi

You may need to add...

EvaluateAfter({@sub});
EvaluateAfter({@sem});

to the beginning of any formula that uses them

Geoff