Set Analysis

[marco_puccetti]

Hello i need to let this script to be selection indipendent:

Count({<RICHIESTA_APERTURA={">=$(=(max(RICHIESTA_APERTURA)-6))<=$(=max(RICHIESTA_APERTURA))"}> }DISTINCT NUMERO_PROPOSTA)

How can i do?

Thanks

Marco

[m_woolf]

Isn't it simply: Count({1<..........

[Anonymous]

Use '1' as set identifier:

Count({1<RICHIESTA_APERTURA={">=$(=(max({1}RICHIESTA_APERTURA)-6))<=$(=max({1}RICHIESTA_APERTURA))"}> }DISTINCT NUMERO_PROPOSTA)

[marco_puccetti]

And on this statement:

Num(Avg(Date(DT_APERTURA_CONTO) - Date(DT_RICHIESTA_APERTURA,'DD-MM-YYYY')),'00')

Thanks

Marco

[sunny_talwar]

Try this:

=Num(Avg({1} Date(Only({1} DT_APERTURA_CONTO)) - Date(Only({1} DT_RICHIESTA_APERTURA),'DD-MM-YYYY')),'00')

[marco_puccetti]

Is it necessary the use of Only?

Marco

[sunny_talwar]

‌If you want to try without them.... You can.... See if without them makes sense, but then you won't be able to use {1} within date function. So try with and without them and see if it makes any difference or not  

[marco_puccetti]

Thanks

Marco

[sunny_talwar]

If it worked, then I would request you to mark correct and helpful answers to close this thread.

Best,

Sunny