Performing calculations with Nintex Forms using the calculated value control

[bimi82]

Hi,

use this function in the calculated value:

If(TextBox1<"1000", "Incidental", "Minor") && If(TextBox1<"10000", "Minor", "Moderate") && If(TextBox1>"20000", "Moderate", "Major") && If(TextBox1>"100000", "Major", "Severe")

I am sure there is a way to shorten it down but ...  not an expert

[shaunlub]

Better to nest the ifs:

If(TextBox1<"1000000", "Incidental", If(TextBox1<"10000000", "Minor", If(TextBox1<"20000000", "Moderate",If(TextBox1<"100000000", "Major","Severe"))))

Tested it; works fine(on-prem, SP2013)

Input no in Text Box control; Calculation in Calculated Value control

[obaidaaqel86]

Thanks a lot ,its working fine now

[obaidaaqel86]

Hi @shaunlub  again

I need ur help again , if I have textbox , the result of this textbox will be based on another 5 textbox's  ( he will take the highest value from these textbox) as following:

EXP1:

TXT1 : Incidental

TXT2: Minor

TXT3: Moderate

TXT4: Major

TXT5: SEVERE

RESRULT TXTBOX will be : SERVERE ( because its the height value).

EXP2:

TXT1 : Incidental

TXT2: Incidental

TXT3: Incidental

TXT4: Major

TXT5: Minor

RESRULT TXTBOX will be : MAJOR ( because its the height value).

EXP3:

TXT1 : Incidental

TXT2: Incidental

TXT3: Incidental

TXT4: Minor

TXT5: Incidental

RESRULT TXTBOX will be : Minor( because its the height value).

EXP4:

TXT1 : Incidental

TXT2: Moderate

TXT3: Incidental

TXT4: Minor

TXT5: Incidental

RESRULT TXTBOX will be : Minor( because its the height value).

how I can handle this in IFCondition Please?

[jaxkookie]

I am having  similar issue with calculation. I am collection date for months spanning several years. To make it dynamic I want to grab current year, then populate a PrevYear, CurrentYear, NextYear, FollowingYear. I only want to calculate current year on new form so it does change on edit. in a field "Year" I can add this formula fn-FormatDate(Current Date, "yyyy") and get current year. the field is set to integer in SharePoint.

When I use Calculated Value set to refresh on view and new mode, using the same formula it returns 0 regardless if the Calculated value is set to String or Integer. I only need to calculate current year correctly because this is what will be posted back to SharePoint, but visually I need the calculated values to display for the user. How can I get current year to populate in a calculated value?

[jaxkookie]

Additionally, I want to sum, or add, all the months for a year. I am using named control, but comes up blank. I entered 1+1 in the formula and it is blank, I am not sure what I am missing