This content has been marked as final. Show 2 replies
I have abit stuck on the calculation,
my issue is I want to do an SUM of Qty base on Location from another table(which is already in relation with the table I am doing calculation.
I.E Total Qty=if(Location="ABC";Sum(ProductQty))
Some how its does give me proper count but in some case it even don't count even if there is record.