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

{{#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)