Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am working in the Load Script; I am working with data of stock for articles when they are under a limit.
But I have two articles which limit of stock is the sum of both.
I want to show this limit of two articles in the same column in a table, that the stock of single articles.
I have tried some posibilities but I always show the amount in a different column.
Thank you very much in advance!
I need some similar to this:
if(EAN = 'xxxxxxx' or EAN = 'yyyyyy', sum(stockLineal), stockLineal) AS Control_stock_stockLineal,
But doesn't run the sum. I have already used the Group by but nothing.