Skip to main content
Nintex Community Menu Bar

Calculated value columns

  • November 26, 2019
  • 4 replies
  • 32 views

Forum|alt.badge.img+4

Hi everyone

 

I have created a column as number which is a calculated value based on another number column divided by a constant value. My example: ColB = ColA/0,23. Sharepoint seems to accept my syntax as correct, but when I want to add the "result column" ie ColB from my example, I cannot find the column in Nintex form builder under SharePoint List Columns. 

 

Is there something I am missing? I could altertanitively do the calculation in Nintex forms. If this is the method I should use, please could you advise on the syntax?

 

Thanks

Kirk

4 replies

Forum|alt.badge.img+12
  • Scholar
  • November 26, 2019

@kirkie4567 ....as far as I know it won't show up in Nintex form.

 

Since Col A is your list column and you're using Nintex form, is there a reason why you're not using form's calculated control to get ColB's value? You can connect your form's calculated control to SLT type list column.


Forum|alt.badge.img+4
  • Author
  • Rookie
  • November 26, 2019

Hi @kunalpatel I do not know the correct syntax. Could you help with that?

 

I am curious why my calculated SharePoint column won't show up in my Nintex form 


Forum|alt.badge.img+12
  • Scholar
  • November 26, 2019

@kirkie4567 .....Please follow below steps:

 

  • ColA --> List column --> accepts integers only
  • ColB --> same as ColA
  • In Nintex form:
    • Add a SLT control --> Select data type as integer and Name it "ctrl_slt_ColA"
    • Add a calculated control ---> In formula add SLT control's Named Control i.e. ctrl_slt_ColA and divide it by 0.23 i.e. ctrl_slt_ColA/0.23
      • Select data type as either decimal or integer
      • If it's decimal then how many decimal you need
      • Also select if you need 1,000 seperator
      • Make sure it does re-calculate the formula in view mode
    • Connect this calculated control to ColB

 

SP calculated column resides in list, it won't show up in Nintex form.


Forum|alt.badge.img+4
  • Author
  • Rookie
  • November 27, 2019

@kunalpatel thanks!! It works well