Hi guys,
Came up with another query, i am creating a BAQ to display partwise OnHandQty from Partwhs table.
I have used Total() function for it. But how i can set the criteria by which i can show part wise total OnHandQty. ???
Are you trying to group by the part?
If so, Remove your criteria.
then you need to add the partnum to the display columns. check the group by.
Add a calculated field to do be the Total which would be sum( PartWhse.OnhandQty )