format=sum incorrect compared with default format (manuall summed)

Running into an issue with incorrect sum compared with Default record view.

Asking for sum of harvest measured in lbs gives me 62

{{#ask: [[Has base type::Harvest]][[Has unit::lbs]] |?Harvest Amount |format=sum}}

While displaying records in table and adding manually i'm getting arund 111+

{{#ask: [[Has base type::Harvest]][[Has unit::lbs]] |?Harvest Amount }}

Reading some other threads here I've tried SemanticAdmin refresh w/ runjobs but the numbers remain the same.

example instance [1]

Justinatethy (talk)

{{#ask: [[Has base type::Harvest]][[Has unit::lbs]]
 |?Harvest Amount
 |format=sum
}} 

A #ask query is by default set to a limit of 50 ($smwgQDefaultLimit).

Your table query on the other hand sets a specific limit hence the discrepancy and I'd suggest you adapt your sum query to the same limitation.

{{#ask: [[Has base type::Harvest]][[Has unit::lbs]]
|?Harvest Amount
|limit=200
}}

James Hong Kong (talk)

Perfect, Thanks MWJames. Interesting to note that format=count is not subject to limit.

Justinatethy (talk)