cancel
Showing results for
Did you mean:
Workflow Hero

## 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,.

Labels: (1)

Tags (1)
11 Replies
Workflow Hero

## 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.

Workflow Hero

## Re: vat calculation

Hi Krishna,

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

Thanks,

Workflow Hero

## Re: vat calculation

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

Workflow Hero

Hi Roger,

It is 20%.

Thanks

Workflow Hero

## Re: vat calculation

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

Workflow Hero

## Re: vat calculation

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

Workflow Hero

## Re: vat calculation

Hi Roger,

Tried it but not working as my VAT is a check box and not a YES/NO field (as in your example).

Is the formula not different having a Checkbox field?

Regards,

Workflow Hero