Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Nintex Community
- :
- Forums
- :
- Nintex for SharePoint
- :
- Performing calculations with Nintex Forms using th...

Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted
##

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Re: Performing calculations with Nintex Forms using the calculated value control

Bruce, Finally I got the problem,

My calculated control is running in a panel, I make it hide when the form loads. On click of a check box I make it visible.

If don't do the above hide and unhide thing, it works. It seems either the calculated control does not work on hide mode or the item value control doesn't trigger the change event.

Anyway managed to achieve the result with conditional calculation

If({some condition},sum(POEstimate),ListColumnValue)

Thanks

Soj

Highlighted
##

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Re: Performing calculations with Nintex Forms using the calculated value control

Sojan,

Yes hiding it removes it from runtime which then causes it not to show. Glad you figured that out.

Shoutout to Bruce Altner for his guidance on this also. Great job community.

Highlighted
##

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Re: Performing calculations with Nintex Forms using the calculated value control

Help with my percentage calculation on Nintex Form.

I have the following formula:

(Expenditure-PlannedExpenditure)/PlannedExpenditure*100

The results shown as this:

The above results are correct (note the decimal places is set to 0 for the percentage).

However, if the planned expenditure is NULL than the percentage is logically infinite, right?

In this case, in the form it is shown as 0% but in the actual SharePoint table the field remains blank.

Using the same approach in Excel; it shows an error:*Note if I use *100 on excel, the percentage does not round to 0 decimal.*

**Question is**; how to modify my current formula on Nintex Form (calculated field)

so that it calculates the percentage as seen in the first 2 pictures but also shows **100%** when Planned Expenditure is 0 (zero)

ThankYou

Highlighted
##

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Re: Performing calculations with Nintex Forms using the calculated value control

Highlighted
##

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Re: Performing calculations with Nintex Forms using the calculated value control

ok then, just did not want to open new section each time I ask a question.

Although it seems that my question is more or less the same as here.

Never mind, created new subject: https://community.nintex.com/message/59691-help-with-percentage-calculation-calc-field

Highlighted
##

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Re: Performing calculations with Nintex Forms using the calculated value control

I'm going to pose my question here because I'll probably just get pointed back to this thread if I start a new one.

My calculation is all messed up. Why can't it handle values 100.00 and over?

Thanks

Kassie

Highlighted
##

Reply

Not applicable

05-19-2017
12:35 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Re: Performing calculations with Nintex Forms using the calculated value control

Or post a new question referring to this by @mentioning it so people know you read it..? :)

Highlighted
##

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Re: Performing calculations with Nintex Forms using the calculated value control

Highlighted
##

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Re: Performing calculations with Nintex Forms using the calculated value control

yea, I ended up figuring it out. This is the same thing I left out with another calculated value I posted previously. You'd think I would learn. :\

Highlighted
##

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Re: Performing calculations with Nintex Forms using the calculated value control

Please I need your help on this, Now I have 2 text box in **Nintex forms**

**TextBox1** **textbox2 **

If user **type or change** value in Textbox1 less than <1,000,000 ---- textbox2 value will be "Incidental".

If user **type or change** value in Textbox1 between (1,000,000 -10,000,000) ---- textbox2 value will be "Minor".

If user **type or change** value in Textbox1 between (10,000,000 -20,000,000) ---- textbox2 value will be "Moderate".

If user **type or change** value in Textbox1 between (20,000,000 -100,000,000) ---- textbox2 value will be "Major".

If user **type or change** value in Textbox1 greater than (>100,000,000) ---- textbox2 value will be "Severe".

I try calculated value to do this , when I use calculated value form not showing when I try to add new item , I try to add rule also this is not helpful.