1. Query on top of a view getting zero value

I am testing below code and have noted that X++ is not getting the value form the DB, X++ is getting zero for field tmpTable.QtyTransfer while if i check the sql being executed it returns not zero values.Could you please check if there is something wrong in my code? Are views not suppose to be used for aggregations?

Original Message:Sent: 02-07-2019 01:37 PMFrom: Francio MaestreSubject: Query on top of a view getting zero value

I am testing below code and have noted that X++ is not getting the value form the DB, X++ is getting zero for field tmpTable.QtyTransfer while if i check the sql being executed it returns not zero values.Could you please check if there is something wrong in my code? Are views not suppose to be used for aggregations?