Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a data set and I want those with invoice type T to be excluded from the calculation. Those with account number 191 are my vat number. Here, I want to show the ones other than those with account number 191 and invoıce type T and distribute them as a percentage to the vat number.
How can I do this on the script side?
Invoıce Number | Invoıce Type | Account Number | Price |
2023000006501 | G | 730 | 2.883.056,72 |
2023000006501 | G | 191 | 588.066,59 |
2023000006501 | G | 770 | 57.276,24 |
2023000006501 | T | 320 | 0,00 |
I want to result:
Invoıce Number | Account Number | Price | VAT | |
2023000006501 | 730 | 2.883.056,72 | %98.05 | 576.60 |
2023000006501 | 770 | 57.276,24 | %1.95 | 11.470,00 |
You can use this expression. {<[Invoıce Type]-={'T'},[Account Number]-={'191'}>} Sum(Price)
but how do you calculate the VAT?
I want to distribute the wattage as a percentage. This is what I really want to do and I don't know how to do it.