topic Re: Percentual no Set Analysis in Brasil

Percentual no Set Analysis

marcelvinicius — Thu, 12 Apr 2018 14:00:19 GMT

Bom dia comunidade

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

sunny_talwar — Thu, 12 Apr 2018 14:02:30 GMT

May be this

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

Re: Percentual no Set Analysis

marcelvinicius — Thu, 12 Apr 2018 14:15:44 GMT

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

marcelvinicius — Thu, 12 Apr 2018 20:53:25 GMT

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

sunny_talwar — Fri, 13 Apr 2018 02:33:23 GMT

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

marcelvinicius — Fri, 13 Apr 2018 12:41:35 GMT

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

Do you can help me?

Att

Re: Percentual no Set Analysis

sunny_talwar — Fri, 13 Apr 2018 12:42:36 GMT

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

Re: Percentual no Set Analysis

marcelvinicius — Fri, 13 Apr 2018 13:46:50 GMT

when i choose one account:

after I choose, the calculation disappears

Re: Percentual no Set Analysis

sunny_talwar — Fri, 13 Apr 2018 13:54:51 GMT

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

Re: Percentual no Set Analysis

marcelvinicius — Fri, 13 Apr 2018 14:02:04 GMT

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

sunny_talwar — Fri, 13 Apr 2018 14:04:21 GMT

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

Best,

Sunny