AnsweredAssumed Answered

Nintex Form Variable calculating as text rather than number

Question asked by jeff_l on Dec 7, 2018
Latest reply on Dec 7, 2018 by jeff_l

I am trying to do a calculation in an Nintex Form Variable, but the calculation is not working as I expect.


The calculation that is not working correctly is:



_intYr is another form variable where I am getting the year portion of a date field on the form.  So in this case, the _intYr is calculating to 2018.  I have _intYr saving as data type integer and that works fine.


In the above calculation, I am getting an answer of 185.  I feel like I should get 23.  The first part _intYr%100 should calculate to 18 and if I only calculate that portion of it by removing the second half of the equation, I do get 18.


The second half should evaluate to 5 and if I remove the first half, it does.


The problem seems to be that when I put them together it adds the two halves of the equation as text rather than numbers.


It seems to return:


18+5 = 185 rather than 18+5 = 23.


Any thoughts on why it is calculating that way or how to fix?  The data type for the form variables (_intYr and this one) are both integer.