Hello Frnds,
We have couple of issues while using ‘INPUTFIELD’. These input fields are being used to capture simulation values for certain parameters. Input field values are used in computation of below straight table. While doing so, we have the following challenges:
a) 1)Unable to use the column name in the expression.
b) 2) How to compute weighted average in the total row.
c) 3)Unable to show the expression total.
Explanation:
Parameters table is used to capture Count of rejected products and the % increase / decrease over the average cost of product type.
Simulation straight table column “Product Cost” is the average cost of each product type. We need to compute the weighted average cost of all product types and display the same in total row.
Rejected count and associated % increase / decrease in cost over the average product cost computations are in the subsequent fields.
Net product count = Product count – Rejected count
Net product amount = Product amount – Rejected amount
Net product cost = Net product amount / Net product count
Attached is the example qvw.
