Problem with SET ANALYSIS

[#1]

Hello community.

I have a problem.

I have a table based on the EXCEL attached file.

I have loaded this file py this statement:

ecriture:

LOAD CDOS, NUMCPT, SENS, MONTANT, DATEECR, PERIODE, MOIS, ANNEE, TRIMESTRE, NUMCPT1, NUMCPT2, NUMCPT3, NUMCPT4 FROM (biff, embedded labels, table is Sheet1$);

I use the following statement

= SUM ($ {<NUMCPT={"56*"}+{"57*"}+{"58*"}, SENS={"D"}, DATEECR> = {"01 / 03/2011 '}, DATEECR <= {"31/03/2011"}>} MONTANT)

to get results but nothing appears.

The problem then is my formula or something else?

Thank you

[stephencredmond]

The syntax is simpler than that:

SUM ($ {<NUMCPT={"56*"}+{"57*"}+{"58*"}, SENS={"D"}, DATEECR> = {"01 / 03/2011 '},DATEECR <= {"31/03/2011"}>} MONTANT)

->

SUM ($ {<NUMCPT={"56*","57*","58*"}, SENS={"D"}, DATEECR = {">01/03/2011<=31/03/2011"}>} MONTANT)

Regards,

Stephen

[stephencredmond]

Sorry - also need to move the $ after the {, not before it:

SUM ( {$<NUMCPT={"56*","57*","58*"}, SENS={"D"}, DATEECR = {">01/03/2011<=31/03/2011"}>} MONTANT)

[#4]

Thanks Sir Stephen Redmond.

It's OK