Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be this
Sum(ValorObj)/Sum(TOTAL {<Ordem = {'1'}>} ValorObj)
Hi stalwar1 thanks ....
I Forgot to use TOTAL....
I need to make some adjustments, but I think this is right.
Thanks Again
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.
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)
I tried both ways, it did not work at all.
Do you can help me?
Att
Which field are you making selection in when you get this output?
when i choose one account:
after I choose, the calculation disappears
When you say account, do you mean Contas, right?
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.