problem with set analyzer

[oarjef]

Hi all,

I found the next problem: i have a column within graph object (simple table) filled with the next expression:

=If((sum( {$<any = {$(#PreviousYear1)}>} amount) = 0) and (sum( {$<any = {$(#PreviousYear2)}>} amount) = 0), sum( {$< any = {$(#CurrentYear)}>} amount), 0)

The expression is ok (it shows the new customers amount, it doesn't matter). But now I would like to get the "new customers number", the total number of new customers (i.e..: NEW=nnnn) on the label of the expression, but I don´t know how could I done it.

Help me, please!

Thanks for all!

[#2]

You can create an expression in the label.

='NEW='&expression

Often, this expression is the same as the one used for the column.

[oarjef]

Thanks Mark,

I know. But my problem is the expression

[#4]

If you set a new customer flag at load time the label expression becomes trivial and you can use the flag to do all sorts of new customer calculations.

Check for (count of orders < date) = 0 and (count of orders > date) > 1 then set flag = 1