One of the canonical ways to perform element-wise checking on an array field would be using $anyElementTrue. You can first use $map to apply your condition(s) on the array to project a boolean array and apply $anyElementTrue on it.

1. use $map to iterate through the Fields array
2. check if the FieldId is equal to amount
3. try to $convert the string value into double.
   • if convert succeed, we keep the double value
   • if convert failed, says it is non-number, we fallback to default value of 0.0(or any value that is less than zero). So this query won’t throw an exception even if your data does not have a value that is parseable into double.
4. chain up the condition of 2 and 3 in an $and and compare with 0. If the conversion failed, it will fall back to 0.0 and will not be selected.

db.collection.aggregate([
  {
    "$match": {
      $expr: {
        "$anyElementTrue": {
          "$map": {
            "input": "$Fields",
            "as": "f",
            "in": {
              "$and": [
                {
                  "$eq": [
                    "amount",
                    "$$f.FieldId"
                  ]
                },
                {
                  $gt: [
                    {
                      "$convert": {
                        "input": {
                          "$first": "$$f.Value"
                        },
                        "to": "double",
                        "onError": 0.0,
                        "onNull": 0.0
                      }
                    },
                    0
                  ]
                }
              ]
            }
          }
        }
      }
    }
  }
])

Mongo Playground

1. Use the $and operator to match multiple conditions instead of if and then.

2. Use the $first operator to get the first element from the array.

3. Also, you have additional braces {} in the $match stage that break the query. Remove the additional braces {}.

db.collection.aggregate([
  {
    $match: {
      $expr: {
        $ne: [
          {
            $filter: {
              input: "$Fields",
              cond: {
                $and: [
                  {
                    $eq: [
                      "$$this.FieldId",
                      "amount"
                    ]
                  },
                  {
                    $gte: [
                      {
                        $toDouble: {
                          $first: "$$this.Value"
                        }
                      },
                      0
                    ]
                  }
                ]
              }
            }
          },
          []
        ]
      }
    }
  }
])

Demo @ Mongo Playground