Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, in this expression
if(SUM({<Mes=, Anio=, TipoCal=>}if (adjudicado=1, CantidadCotizada))
- sum({<Mes=, Anio=, TipoCal=>} CantidadEntregada) = 0,
SUM ({<Mes=, Anio=, TipoCal=>} (CantidadEntregada)))
What i'm doing is a sum, but i have this Condition
if(SUM({<Mes=, Anio=, TipoCal=>}if (adjudicado=1, CantidadCotizada))
- sum({<Mes=, Anio=, TipoCal=>} CantidadEntregada) = 0
Actually, is a very simple thing. If the sum of the first field - the sum of the second field is equal to 0, we do the sum. And all of those expressions have set analisys, because i dont wanna have my expressions influenced by "mes", "anio", "tipocal"
Ok, here is the problem. The conditional works with the total of Cantidad1 - Cantidad2, but i wanna divide this by "Article" and "Group" for example.
Should i use aggr function? how i use this function with the set analysis?
thank you!
Greetings
Can you pls explain what you mean by - divide by "Article" and "Group"
Is this in a straight table?
Can you attach a sample file?
Thanks