Skip to main content
Nintex Community Menu Bar

Nintex forms calculated value math function

  • January 31, 2020
  • 3 replies
  • 13 views

Forum|alt.badge.img+3

Hi,

My calculation below works on Sharepoint form but doesn't work on nintex and comes up 0 regardless of what I put in place of the columns:

 

(Column1 -(Column2 *(1+Column3 %)+Column4 /2000+Coumn5 / 2000))*40

 

Also I need the result to show in realtime. TIA.

3 replies

Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • February 2, 2020
Hi,

The only thing I can see taht I dont understand is : (1+Column3 %)
Is that a percentage or modulo or?

Forum|alt.badge.img+3
  • Author
  • February 3, 2020

thanks for the reply

it's percentage (1+ "Column3" %)


Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • February 3, 2020
Nintex will not recognise that notation so it will need to be changed.

The equivalent of the SharePoint formula (Column2 *(1+Column3 %)would be ((Column2*(Column3/100))+Column2).