{"id":5988,"date":"2017-12-15T19:49:42","date_gmt":"2017-12-15T19:49:42","guid":{"rendered":"https:\/\/alt2.minisoft.com\/support\/?p=5988"},"modified":"2020-07-02T09:23:06","modified_gmt":"2020-07-02T16:23:06","slug":"math-calculations-with-arrays","status":"publish","type":"post","link":"https:\/\/minisoft.com\/support\/math-calculations-with-arrays\/","title":{"rendered":"Math Calculations with Arrays"},"content":{"rendered":"

NOTE: This example makes use of the\u00a0Calculation, Set Variable and Sum procedures. More information can be found in the following posts:
\nCalculation and Sum Procedures<\/a>
\nSet Variable<\/a><\/p>\n

To perform math calculations with an array, it’s necessary to create a variable that contains the array and then use the Calculation procedure to perform the required math functions. In the examples listed below, the Calculation procedure is used to multiply a set of values. In one example, the Sum procedure is used to add the total to a separate variable. In another example, the Set Variable procedure is used. To follow along, download the files here: Calculation<\/a><\/p>\n

Method One: Sum Procedure<\/h2>\n

This example uses the project ‘Sum1’.<\/p>\n

1. Add a variable containing the array of values.<\/p>\n

\"\"<\/a><\/p>\n

2. Name the variable or accept the defaults. Select OK.<\/p>\n

\"\"<\/a><\/p>\n

3. Add a variable by position by right clicking the form and selecting Add Variable > By position. This variable will be used as the multiplier.<\/p>\n

\"\"<\/a><\/p>\n

4. Right click the multiplier variable and select Add Function > Set Value. In this instance, we will be using a multiplier of 3.<\/p>\n

\"\"<\/a><\/p>\n

5. Create a copy of the variable containing the array of values but give it a different name (‘TempValue’ in this example).<\/p>\n

\"\"<\/a><\/p>\n

\"\"<\/a><\/p>\n

6. Add a variable by position by right clicking the form and selecting Add Variable > By position. This variable will be used as the sum.<\/p>\n

\"\"<\/a><\/p>\n

7. Right click the form and select Add Pre-condition Procedure > Calculation. The Procedure Properties dialog box will display. Name the procedure (‘Multiply’ in this example). From the drop-down menu, select the variable which contains the array to calculate. Select OK.<\/p>\n

\"\"<\/a><\/p>\n

8. The Calculate dialog box will display. Select Multiply from the drop-down menu. Next, select the Variable radio button and the variable which contains the multiplier. Select OK.<\/p>\n

\"\"<\/a><\/p>\n

9. Right click the procedure (which is named ‘Multiply’ in this example) and select Add Action > Set Variable. The Set Variable Action dialog box will display. From the Variable drop-down menu, select the ‘TempValue’ variable created earlier (See step #5).<\/p>\n

\"\"<\/a><\/p>\n

10. Right click the form and select Add Pre-condition Procedure > Sum. The Procedure Properties dialog box will display. Select the\u00a0‘TempValue’ variable created earlier (See step #5). Select OK.<\/p>\n

\"\"<\/a><\/p>\n

11. The Sum into Variable Action dialog box will display. From the Variable drop-down menu, select the ‘Sum’ variable created earlier (See step #6). Select OK. The ‘Sum’ variable will now have the total.<\/p>\n

\"\"<\/a><\/p>\n

Method Two: Set Variable Procedure<\/h2>\n

This example uses the project ‘Sum2’.<\/p>\n

1. Add a variable containing the array of values.<\/p>\n

\"\"<\/a><\/p>\n

2. Name the variable or accept the defaults. Select OK.<\/p>\n

\"\"<\/a><\/p>\n

3. Add a variable by position by right clicking the form and selecting Add Variable > By position. This variable will be used as the multiplier.<\/p>\n

\"\"<\/a><\/p>\n

4. Right click the multiplier variable and select Add Function > Set Value. In this instance, we will be using a multiplier of 3.<\/p>\n

\"\"<\/a><\/p>\n

5. Add a variable by position by right clicking the form and selecting Add Variable > By position. This variable will be used as the sum (‘TempSum’ in this example).<\/p>\n

\"\"<\/a><\/p>\n

6. Right click the form and select Add Pre-condition Procedure > Set Variable. The Procedure Properties dialog box will display. This procedure will preset the value of ‘TempSum’ to null. Select the N\/A system variable from the drop-down menu.<\/p>\n

\"\"<\/a><\/p>\n

7. The Set Variable Action dialog box will display. Select the\u00a0‘TempSum’ variable and select OK.<\/p>\n

\"\"<\/a><\/p>\n

8. Right click the Actions icon beneath the procedure and select Add Function > Set value.<\/p>\n

\"\"<\/a><\/p>\n

9. The Set Value dialog box will display. Enter a value of ‘0’ in the Constant field and select OK.<\/p>\n

\"\"<\/a><\/p>\n

10. In the Project window, left click the ‘Set value to 0’ function and drag it above the ‘Set variable TempSum’ procedure. This will set ‘TempSum’ to 0.<\/p>\n

\"\"<\/a><\/p>\n

\"\"<\/a><\/p>\n

11.\u00a0Right click the form and select Add Pre-condition Procedure > Calculation. The Procedure Properties dialog box will display. Select the variable which contains the array to calculate (‘value’ in this example). Select OK.<\/p>\n

\"\"<\/a><\/p>\n

12.\u00a0The Calculate dialog box will display. Select the Multiply option and select the variable for the multiplier created earlier (See step #3). Select OK.<\/p>\n

\"\"<\/a><\/p>\n

13. Right click the Actions icon beneath the procedure and select Add Action > Calculation.<\/p>\n

\"\"<\/a><\/p>\n

14. Right click the Actions icon beneath the procedure and select Add Action > Calculation.\u00a0Select the Add option and select the ‘TempSum’ variable. Select OK.<\/p>\n

\"\"<\/a><\/p>\n

15. Right click the Actions icon beneath the procedure and select Add Action > Set Variable.<\/p>\n

\"\"<\/a><\/p>\n

16. The Set Variable Action dialog box will display. Select the ‘TempSum’ variable. Select OK.\u00a0The ‘TempSum’ variable will now have the total.<\/p>\n

\"\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

NOTE: This example makes use of the\u00a0Calculation, Set Variable and Sum procedures. More information can be found in the following posts: Calculation and Sum Procedures Set Variable To perform math calculations with an array, it’s necessary to create a variable that contains the array and then use the Calculation procedure to perform the required math […]<\/p>\n","protected":false},"author":75,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[361],"_links":{"self":[{"href":"https:\/\/minisoft.com\/support\/wp-json\/wp\/v2\/posts\/5988"}],"collection":[{"href":"https:\/\/minisoft.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/minisoft.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/minisoft.com\/support\/wp-json\/wp\/v2\/users\/75"}],"replies":[{"embeddable":true,"href":"https:\/\/minisoft.com\/support\/wp-json\/wp\/v2\/comments?post=5988"}],"version-history":[{"count":10,"href":"https:\/\/minisoft.com\/support\/wp-json\/wp\/v2\/posts\/5988\/revisions"}],"predecessor-version":[{"id":8182,"href":"https:\/\/minisoft.com\/support\/wp-json\/wp\/v2\/posts\/5988\/revisions\/8182"}],"wp:attachment":[{"href":"https:\/\/minisoft.com\/support\/wp-json\/wp\/v2\/media?parent=5988"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/minisoft.com\/support\/wp-json\/wp\/v2\/categories?post=5988"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/minisoft.com\/support\/wp-json\/wp\/v2\/tags?post=5988"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}