multiply different factors

[Bukan4x4]

Hello there,

Help me with this please: I need to calculate the "Result Taxes" of multiple Companies.

Company	Taxes	Turnover	Cost
A	0.2	100	50
B	0.3	150	25
C	0.2	200	70

Also, I Have different money Exchange rate:

Money	exchange_rate
Dolar	700
Eur	900

I have this variable working fine:

vTurnover= [Turnover]*[exchange_rate]

vCost =[Cost]*[exchange_rate]

vResult= vTurnover - vCost

But I tried to calculated Result Taxes this way:

=vResult*Taxes

the result is showing correctly when companies selected have the same Taxes values, Like Companie A and C, if Companies A and B are selected no result is shown.

How I can solve this?

Thanks in advance.

[Anil_Babu_Samineni]

Perhaps this?

((Sum([Turnover])*Sum([exchange_rate]))-(Sum([Cost])*Sum([exchange_rate])))*Sum(Taxes)

[Bukan4x4]

Thanks, but that isn't the result.

[JMAROUF · Accepted solution]

Hi @Bukan4x4 

try this.

vResultTax=sum(((Turnover-Cost)*exchange_rate)*Taxes)

[Anil_Babu_Samineni]

When you say that is not the expected result, can you brief little more to understand?

[Bukan4x4]

Anil, isn't correct because you sum all Taxes values and this result is multiplied by the other values.

In my tables, if companies A and B are selected, SUM(taxes) = 0,5. Is not the expected result.

Thanks anyway.

[Bukan4x4]

Thanks JMarouf, That worked!

But my real code is pretty more complicated than I resume here, I expected to calculate the Tax using my variables directly, but I think isn't possible.