...
The general rule is simple:
- On the record level the non-base measures will return the total value of the record including taxes
- On the record level the base measures will return the total value of the record including taxes in base currency
On the item level both the non-base and base measures will return the value excluding taxes in the currency and base currency respectively
Tip |
---|
If the invoice is in base currency - both measures will return the same value |
Example
Note |
---|
Let's assume you have sold 1 item which costs 100 EUR or approximately 109 USD and the VAT is 21% and the invoice is in USD. |
In Sales cube the measures will return these numbers:
Measure | Amount | Why |
---|---|---|
Invoice amount | 131.89 USD | 109 USD + 21% VAT (and other taxes if applicable) |
Tax amount | 22.89 USD | Total tax amount in USD |
Invoice base amount | 121 EUR | 100 EUR + 21% VAT |
Tax base amount | 21 EUR | Total tax amount in EUR |
Item amount | 109 USD | Total value in currency ex taxes |
Item base amount | 100 EUR | Total value in base currency ex taxes |
Tip |
---|
If you wish to have a measure that returns total value ex taxes on the record level you can create one as a simple calculated member that subtracts the Tax amount from the Invoice amount etc. |