Variable calculation

[dave_282]

I have a calculation which does not appear to be displaying properly, here is the syntax. It should only be bringing back the A tax code value but without the tax code in the block you can see it’s not right. The first invoice, 744656 for example should be showing 201.53 because that’s the tax code A value but its also including the B value of 26.40 and is therefore incorrectly showing 227.93. Does anyone know what I need to change the below syntax to, to get it to work as required?

=Sum(If([Vat Code]=“A”;Sum([Invoice Value]);0))

[MarkP]

Something like =Sum([Invoice Value] Where ([Vat Code]=“A”)) should work.

Without knowing the full contents of the block, that’s the most I can offer.

[N8AKTIV]

delete the second sum()

[dave_282]

thank you, thats sorted