Skip to main content

Hi,

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

4989iC312E48A64FDB4A9.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

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
Thanks! It worked!

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings