Hi Everyone,
I have a question relating to a calculated field in a Nintex for SP2013 environment.
I have several drop down fields with numeric values which are summed together in a calculated field called 3TotalValue.
I then have another calculated field called 3TotalRatingText which I am trying to auto populate with a text value, which is determined based on the value in the first calulated field 3TotalValue.
I am currently using the forumula shown below:
=IF(3TotalValue>=45, "Large", IF(3TotalValue>=26, "Medium", IF(3TotalValue<=25,"Small")))
But when loading the form or previewing it, the whole form is blank, so obviously something is seriously wrong.
I also have a second set of logic I need to apply, being that if any of the individual drop down values used to origionally determine 3TotalValue are > 4, the value of 3TotalRatingText should be changed from Small to Medium. Of course if 3TotalValue is already >=26, it is Medium, and if >=45, it is Large.
Does all of this make sense?
Can anyone help?
Your assistance, as always, is much appreciated.