If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Help me with this please: I need to calculate the "Result Taxes" of multiple Companies.
Also, I Have different money Exchange rate:
I have this variable working fine:
vResult= vTurnover - vCost
But I tried to calculated Result Taxes this way:
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.
When you say that is not the expected result, can you brief little more to understand?
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 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.