Nintex Newbie

## vat calculation

Hi,

I have some difficulties with the following

- How can I set a rule in Nintex forms so when I enter a value in "Cost" field and without ticking the box VAT.  The value of the  Cost field should appear in "Total"

- And when i tick the VAT box it should calculate the Cost + VAT in the Total field (or do i need somehow a calculated value instead of Total field)

Regards,.

11 Replies
Workflow Veteran

## Re: vat calculation

Hi,

I would prefer to use calculated field to show total value, if a text field is being used to show total, you have to write jquery to handle lost focus event on "Cost" field.

Also plan your formula for calculated field to calculate VAT also if it is checked.

Nintex Newbie

## Re: vat calculation

Hi Krishna,

What is the formula of calculating Cost plus when VAT box is ticked in a caculated value?

Thanks,

Workflow Veteran

## Re: vat calculation

What is the VAT value that needs to be added to Cost?

Nintex Newbie

Hi Roger,

It is 20%.

Thanks

Workflow Veteran

## Re: vat calculation

I created a calculated column called Total with this formula: =IF(VAT,Cost*1.2,Cost)

Workflow Veteran

## Re: vat calculation

I just used the OOTB SharePoint functionality for this. Why create a custom form when the OOTB stuff will work?

Nintex Newbie

## Re: vat calculation

Those few fileds are just a part of a bigger FORM.....

Workflow Veteran

## Re: vat calculation

Regardless you can create the fields and then add them to the Nintex form. I would take advantage of OOTB if possible.

Nintex Newbie