Help in set_analysis syntax

[Anonymous]

Hi guys,

I have a set_analysis formula:

=Num(Count(Distinct {$<QtaGiacente={"<>0"}, AnnoUltimoMovimento={"<2005"}>} CodiceArticolo),'#.##0')

and I like to replace the value 2005 with the variable AnnoInizioObsolescenza

Should someone help me with the properly syntacs?

Thanks a lot.

N.

[Gysbert_Wassenaar · Accepted solution]

If AnnoInizioObsolescenza is a variable and not a field then you do it like this:

=Num(Count(Distinct {$<QtaGiacente={"<>0"}, AnnoUltimoMovimento={"<$(AnnoInizioObsolescenza)"}>} CodiceArticolo),'#.##0')

But if AnnoInizioObsolescenza is a field then all bets are off. See this document: set_analysis_intra-record.qvw

[Anonymous]

Try this:

=Num(Count(Distinct {$<QtaGiacente={"<>0"}, AnnoUltimoMovimento={"<$(AnnoInizioObsolescenza)"}>} CodiceArticolo),'#.##0')

[Anonymous]

Marc, your answer il right too, but I'm not able to set it so (actually I think it isn't possible ).

Thank you so much to everybody.

N.