DQL using sum(map(...)) inside dataviewjs returns null values

[holroy]

I was doing some research for a forum post, when I discovered this anomaly which I'm not certain is a bug or a feature or just me being silly. But I've done the same stuff multiple times in the past with no issue.

The workflow for me to trigger this was:

• Write a working TABLE query, using a series of FLATTEN, split, sum and map to manipulate data
• To debug this, insert that query into dataviewjs, using const pages = await dv.query( ... )
• Followed by console.log(pages.value.values) to examine my result
• And output the result using dv.table(pages.value.headers, pages.value.values)

Usually the output from the first line, is equal to the output of the next three lines (within the dataviewjs script), but this time the sum column is nullified, and I get this output from my queries:

The attached note contains all the data, and both queries used to produce this image, and I'm stumped as to why I get null values in the second variant. Can someone please explain what's happening, or whether this is a (known?) bug or feature, or something like that?

sum of map inside dataviewjs.md

For the record I'm using Obsidian 1.1.9 (installer 1.0.0), and Dataview 0.5.55