Hello! Is possible in Aurelius to do a conditional sum? Example: Select PRODUCT_ID, Sum(QTY * If(STOCK_INFLUENCE = "-", -1, 1)) As ON_STOCK From doc_items where PRODUCT_ID=7 I'm trying to sum the quantity based on the document type (+qty if document is incoming, -qty if it is outgoing). Kind …

Yes, for condition part you should use the Condition projection: https://doc.tmssoftware.com/biz/aurelius/guide/queries.html#condition TProjections.Condition( Linq['StockInfluence'] = '-', Linq.Literal<Integer>(-1), Linq.Literal<Integer>(1))

Conditional sum in query

BIZ TMS Aurelius

GOMEZEL_DINO (GOMEZEL DINO) June 13, 2023, 10:00am 3

I meant to do this using Linq. Is possible to conditionally sum with Linq?

Topic		Replies	Views
Filtering a projection like "HAVING" in SQL TMS Aurelius	4	491	April 3, 2021
Auxílio com consultas onde é necessário group by com sum em campos TMS Aurelius	3	178	March 3, 2023
SQL HAVING Clause TMS Aurelius	14	903	January 20, 2022
Query bit logic TMS Aurelius	3	192	April 12, 2023
Query data with "OR" condition in many code rows TMS Aurelius	13	668	January 16, 2020

Conditional sum in query

Related topics