Nintex forms calculated value math function

  • 31 January 2020
  • 3 replies
  • 3 views
E
Badge +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

SimonMuntz
Userlevel 6
Badge +22
Hi,

The only thing I can see taht I dont understand is : (1+Column3 %)
Is that a percentage or modulo or?
Cool Nintex courses: https://learn.nintex.com/
E
Badge +3

thanks for the reply

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

SimonMuntz
Userlevel 6
Badge +22
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).
Cool Nintex courses: https://learn.nintex.com/

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings