cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
WouterF
Nintex Newbie

Dynamical total price field on Nintex Form

Jump to solution

Hi,

I am creating a Nintex form in Office 365 that has 3 currency input fields:

nintex form.PNG

The field Total A needs to update and show the sum of these three fields when one of these fields is filled in:

  • Investments
  • Labour Force
  • Others

I tried to do this using a formula, but this does not work, the "Total A" field does not change when entering values:

sum([SharePoint Columns].[InvestmentsA], [SharePoint Columns].[MiscLabourA],[SharePoint Columns].[MiscOthersA])

I also tried it with a "Form rule" but also no luck with this.

I am doing something wrong?

Thanks in advance.

Wouter

Labels: (1)
0 Kudos
Reply
2 Replies
v-tmasenko
Nintex Newbie

Re: Dynamical total price field on Nintex Form

Jump to solution
You're close with the form rule but you need to select the [Form] context.
Plus formulas can only be used to define variables. You can't set the value in the rule directly. (only constants can are allowed to do that)

1) create a variable called say, LandsSum of Type Decimal with the Value of the following:
sum([Form].[InvestmentsA],[Form].[MiscLabourA],[Form].[MiscOthersA])

2) create a rule:
if InvestmentsA Is filled OR MiscLabourA Is filled OR MiscOthersA is filled
then TotalA Value LandsSum
else TotalA 0.00
0 Kudos
Reply
WouterF
Nintex Newbie

Re: Dynamical total price field on Nintex Form

Jump to solution
Thanks! It worked!
0 Kudos
Reply