Using Sum({Row Set}, '') and Developing Filter for the Rows to be Summed (Row Set Transformation Too
Hello,
- TEST1 I have run a test using the setup below as an Input Argument on the BService Row Set Transformation Toolkit, with Method = Hierarchical Transform. This was added as a step in the Workflow process, Dynamic Pricing Procedure.
Input Arugment | Type | Value |
On Parent Row 1 | Literal | {Row.NRC CxTotal} = IIF({Row.Product Id} = "1-9PQIJI", Sum({Row Set}, 'Temp MRC Net Price'), "") |
- The Product Id reference is used to identify the Root level Order Line Item
- NRC CxTotal was used for testing purposes as the target
- Temp MRC Net Price is a temporary variable defined in preceding steps in WF Dynamic Pricing Procedure. This field is referenced in other WF steps of the Dynamic Pricing Procedure.
0