Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Try this:
=Num(Count(Distinct {$<QtaGiacente={"<>0"}, AnnoUltimoMovimento={"<$(AnnoInizioObsolescenza)"}>} CodiceArticolo),'#.##0')
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.