JSONata Tutorial

Calculations

Calculation & Aggregation

← PreviousNext →

Calculations

Task

Calculate the total line item amount per main line item (qty * unit_price) of all sub_line_items as well as the subtotal which includes all items.

Hint: This requires understanding of query composition

Your Expression
Your Result
No data
Input JSON
{
    line_items:[
      {
        product_id:1,
        sub_line_items:[
          {
            product_id:3,
            quantity:5,
            unit_price:10
          }
        ]
      },
      {
        product_id:2,
        sub_line_items:[
          {
            product_id:4,
            quantity:3,
            unit_price:10.99
          },
          {
            product_id:5,
            quantity:9,
            unit_price:44.77
          }
        ]
      }
    ]
}
Expected Output
{
    line_items:[
      {
        product_id:1,
        line_item_amount:50
      },
      {
        product_id:2,
        line_item_amount:435.9
      }
    ],
    summary:{
      subtotal:485.9
    }
}