topic Load Script group and percantege in App Development

Load Script group and percantege

krmvacar — Tue, 14 May 2024 12:26:59 GMT

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

Re: Load Script group and percantege

JHuis — Tue, 14 May 2024 12:41:30 GMT

You can use this expression. {<[Invoıce Type]-={'T'},[Account Number]-={'191'}>} Sum(Price)

but how do you calculate the VAT?

Re: Load Script group and percantege

krmvacar — Tue, 14 May 2024 12:46:48 GMT

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.