
Creator
2020-12-07
05:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sum of data is under the limit and show in the same column
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!
482 Views
1 Reply

Creator
2020-12-07
06:19 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
449 Views
