cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

vat calculation

Jump to solution

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)

Any help please!

Regards,.

Adam

Labels: (1)
Tags (1)
Reply
11 Replies
Workflow Hero

Re: vat calculation

Jump to solution

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.

0 Kudos
Reply
Workflow Hero

Re: vat calculation

Jump to solution

Hi Krishna,

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

Thanks,

Adam

0 Kudos
Reply
Workflow Hero

Re: vat calculation

Jump to solution

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

0 Kudos
Reply
Workflow Hero

Re: vat calculation

Jump to solution

Hi Roger,

It is 20%.

Thanks

0 Kudos
Reply
Workflow Hero

Re: vat calculation

Jump to solution

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

Reply
Workflow Hero

Re: vat calculation

Jump to solution

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

0 Kudos
Reply
Workflow Hero

Re: vat calculation

Jump to solution

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,

Adam

0 Kudos
Reply
Workflow Hero

Re: vat calculation

Jump to solution

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

0 Kudos
Reply
Workflow Hero

Re: vat calculation

Jump to solution

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

0 Kudos
Reply