[CX] Difference in results from n1ql for "SUM(d.test_rate) % COUNT(d.join_yr)"

Query issued:

SELECT d.job_title, SUM(d.test_rate) % COUNT(d.join_yr) as avg_per_year from default_shadow d group by d.job_title;

Result in cbas:

$ curl -s --data pretty=true  --data-urlencode "statement@file.txt" http://172.23.107.182:8095/analytics/service

{

	"requestID": "5bab3389-ddfb-459c-902e-107a9dcec907",

	"signature": "*",

	"results": [ {

			"avg_per_year": 606.4799999999941,

			"job_title": "Support"

		}, {

			"avg_per_year": 606.4799999999914,

			"job_title": "Engineer"

		}, {

			"avg_per_year": 606.4799999999941,

			"job_title": "Sales"

		} ]

	,

	"status": "success",

	"metrics": {

		"elapsedTime": "57.092680ms",

		"executionTime": "56.470180ms",

		"resultCount": "3",

		"resultSize": "206"

	}

}

Result with n1ql:

[

  {

    "avg_per_year": 606.4799999999932,

    "job_title": "Sales"

  },

  {

    "avg_per_year": 606.4799999999941,

    "job_title": "Engineer"

  },

  {

    "avg_per_year": 606.4799999999968,

    "job_title": "Support"

  }

]

Attaching  backup of dataset.