the usual way would be to have a conditional iif and the calculation has to be based on the original calculation- something like this in the controlsource
=sum(iif([vatpercent]=12,[quantity]*[AgreedUponPrice]*[vatpercent]/100,0))
you'll need to check the 12 - it might be 0.12 and formatted to look like 12,00%, can't tell from the info provided. ditto the calculation
Last edited by CJ_London; 05-12-2020 at 08:13 AM.
it is 0.12 and formatted as percent so you're right about that
I'll give it a try
Got an error message "Unvalid syntax"
need to see the actual code you are actually using
I tweaked it a little an now it works like a charm. Thank you very much for your help