Field restriction problem

[neefken]

Hello again,

My next problem !

I have in my db a field called 'total VAT' and it's normally the sum of the field 'subtotal VAT 6%" and the field 'subtotal 21%'. But now I have to become the following :

the result in 'total VAT' should be 0 when the entry in the field 'Country' does not equals 'Belgium' and when there's an entry in the field 'VAT number'.

Can somebody help me out here ?

Thanks !

Neefken

Belgium

[danjacoby]

If (Country * "Belgium" and not IsEmpty (VATnumber), 0, SubtotalVAT6% + Subtotal21%)

[neefken]

Thanks !

It all work great now !