10 Replies Latest reply: Apr 13, 2018 10:04 AM by Sunny Talwar

# Percentual no Set Analysis

Seguinte, preciso criar uma tabela com valores percentuais, porém ao tentar usar um set analysis do valor que preciso, só busca valor para o valor correspondente (de faturamento);

Tenho o valor de objetivo através da medida: SUM(ValorObj) e preciso que todas as contas dividam pelo valor de Faturamento (Ordem = 1):

No exemplo abaixo a conta Lucro Bruto tem que ser 8%, Comissão Venda de Consorcio - 0,20%, e assim por diante.

• ###### Re: Percentual no Set Analysis

May be this

Sum(ValorObj)/Sum(TOTAL {<Ordem = {'1'}>} ValorObj)

• ###### Re: Percentual no Set Analysis

Hi stalwar1 thanks ....

I Forgot to use TOTAL....

I need to make some adjustments, but I think this is right.

Thanks Again

• ###### Re: Percentual no Set Analysis

Good afternoon friend,

I am only in a situation, when selecting a certain account, the calculation disappears, how can I solve it?

Thank you again.

• ###### Re: Percentual no Set Analysis

Which field are you selecting in? Contas? May be try this

Sum(ValorObj)/Sum(TOTAL {<Ordem = {'1'}, Contas>} ValorObj)

or this

Sum(ValorObj)/Sum(TOTAL {1<Ordem = {'1'}>} ValorObj)

• ###### Re: Percentual no Set Analysis

I tried both ways, it did not work at all.

Do you can help me?

Att

• ###### Re: Percentual no Set Analysis

Which field are you making selection in when you get this output?

• ###### Re: Percentual no Set Analysis

when i choose one account:

after I choose, the calculation disappears

• ###### Re: Percentual no Set Analysis

When you say account, do you mean Contas, right?

• ###### Re: Percentual no Set Analysis

Thanks again for the friend help, with this formula you passed:

Sum (ValueObj) / Sum (TOTAL {<Order = {'1'}, Accounts>} ValueObj)

I got the account name in the script and solved it.

Thank you very much.

• ###### Re: Percentual no Set Analysis

Hahahaha nice... I am glad you were able to figure it out in the end.

Best,

Sunny