Does anybody has any ideas to get a table like this in Nintex
I need to do some simple math calculation like division , average etc too on this table
Solved! Go to Solution.
Could you provide some more information? Is this a table that is generated via Nintex Workflow and then sent in an email? Are you looking to do this in a Nintex Form?
Thanks for clarifying. You can build tables like these in Nintex Forms and perform calculations within them. I'm assuming you would have number input fields in the each of the year cells. In the YTD and AVG fields, you can use a Calculated Value control with Runtime Functions (avg, count, sum) and formulas to perform calculations based on the year cells.
Hi Marta. You can use the Avg runtime function in the Formula field of a Calculated Value control. Below is an example of how to use it.
I have a Repeating Section control in a form that contains a Cost, Quantity, and OrderTotal field. The Cost control is a Single Line Textbox with a data type of Currency, the Quantity control is a Single Line Textbox with a data type of Integer, and the OrderTotal control is a Calculated Value with a data type of Currency with a formula of Cost*Quantity. The User enters data in the Cost and Quantity fields, and the OrderTotal is automatically calculate. Since it's a Repeating Section, you can add more lines.
I placed a Calculated Value control named AvgOrderTotal outside the Repeating Section that automatically calculates the average of all the OrderTotal fields. The formula in the AvgOrderTotal is:
Below are screenshots of the form and controls configuration.