Calculation formula not working

Question

I want to build a calculation that returns the sum from integer fields and display them in a text field, but it is not working. I have tried everything I can think of. Followed instructions from Formulas site.

${GI1}+${GI2}+${GI3}+${Detention_Fac}+${Detention_Fac2}

I have the xsl file attached.

Form 2.xlsx

GISManager4 · Answer

The calculation field is not adding the fields together. It will show the value for 1 field, but as soon as I use + the formula does not work.

GISManager4 · Answer

I made the changes you suggested and the calculation still does not work.

JayantaPoddar · Answer

You have used the text fields for calculation. You should use

${Num_GI1}+${Num_GI2}+${Num_GI3}+${Num_Detention_Fac}+${Num_Detention2}

Also change the Type of Num_Detention2 to integer.