7 Replies Latest reply: Mar 20, 2017 3:23 PM by Claudio Reis

# Set Analisys collunm conditional

Podem me ajudar por favor?

É possível efetuar um cálculo com set analisys utilizando o nome de uma coluna calculada?

segue exemplo:

• ###### Re: Set Analisys collunm conditional

Not within the Aggr() function, you can't. Within Aggr() you need to replace the expression label with the actual expression itself

• ###### Re: Set Analisys collunm conditional

Hi Sunny!

I override but it worked only when I select a line.

Follows the new expression:

Count(DISTINCT If(Aggr(NODISTINCT Count(Qtd_Uso_PDV_FH),Agrupamento) >= \$(=Floor((1-(Simul_Prod - AGGR(if(Qtd_Uso_PDV_FH >= MAX(AGGR(NODISTINCT MAX({\$<Faixa_Horario,Semana,Nro_PDV,Dia>}Qtd_Uso_PDV_FH),Nro_Loja)), sum({\$<Faixa_Horario,Semana,Nro_PDV,Dia>}Tempo_Cupom)),Nro_Loja,Qtd_Uso_PDV_FH) /

AGGR(if(Qtd_Uso_PDV_FH >= MAX({\$<Faixa_Horario,Semana,Nro_PDV,Dia>}AGGR(NODISTINCT MAX({\$<Faixa_Horario,Semana,Nro_PDV,Dia>}Qtd_Uso_PDV_FH),Nro_Loja)), sum({\$<Faixa_Horario,Semana,Nro_PDV,Dia>}Tempo_Uso)),Nro_Loja,Qtd_Uso_PDV_FH))) * Max(Aggr(Count({\$<Faixa_Horario,Semana,Dia>}DISTINCT Nro_PDV),Nro_Loja,Data)))), Data))

• ###### Re: Set Analisys collunm conditional

It would be difficult to comment without having a look at the app and playing around with it. Would you be able to share a sample?

• ###### Re: Set Analisys collunm conditional

Hi, Sunny!

I attached a template.

Thanks!

• ###### Re: Set Analisys collunm conditional

Hi, Sunny!

I attached a template.

Thanks!

• ###### Re: Set Analisys collunm conditional

What are you trying to do with this part?

Aggr(NODISTINCT Count(Qtd_Uso_PDV_FH),Agrupamento)

This is part is giving no result in your table...

• ###### Re: Set Analisys collunm conditional

Hi, Sunny!

My idea is that this expression could calculate the frequency, but only works if you select a line.

Could you help me build the correct expression?