Above

[Anonymous]

Hello everyone, I have doubts with Above. I need to add the 1 of my column #Subio

the expression you used was

If Above (Price) <Price )

But at the time of adding this expression does not give me anything in the column of T

otal Subio For this column

I did the expression = Aggr (sum (if ( Above (Price) <Price ), CCO_CompanyName, CC_Mes)

[sunny_talwar]

What are you summing?

=Aggr(Sum(If(Above(Price) < Price, TrueCondition), CCO_CompanyName, CC_Mes)

[Anonymous]

The times I have 1 in the #Subio column by CC_Mes and CCO_Name

[sunny_talwar]

Not sure I understand

[Anonymous]

I want to count the 1 of the #Subio column but per month

[sunny_talwar]

What is #subio column's expression?

[Anonymous]

if(

Above(Precio)<Precio,1,0

)

[sunny_talwar]

May be try this

=Aggr(Sum(If(Above(Price) < Price, 1, 0), CCO_CompanyName, CC_Mes)

or just this

=Sum(If(Above(Price) < Price, 1, 0)

[Anonymous]

I already tried both but it does not work

[Anonymous]

In fact a parentesis is missing but still does not work

=Aggr(Sum(If(Above(Precio) < Precio, 1, 0)),CCO_CompraANombre, CC_Mes)