Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
Please can you help change the following expression to include values between 20000 and 50000 - I just cannot get it to work!
=Sum(Aggr(If(Sum([Price]) <=50000 and Credit_code='A', Sum([Price])), ReferredTo))
Thanks
May be this?
Sum(Aggr(If(Sum(Price) >= 20000 and Sum(Price) <= 50000, Sum(Price)), ReferredTo))
May be this?
Sum(Aggr(If(Sum(Price) >= 20000 and Sum(Price) <= 50000, Sum(Price)), ReferredTo))
Simple as that!!
Thankyou
Hi,
another possible way
1: sum(aggr(sum({<Price={">=20000<=50000"}>}Price),ReferredTo))
or
2: sum(aggr(if(price>=20000 and price <=50000,price),ReferredTo))
Regards,
=sum({<Price= {">=20000<=50000"},Credit_code={'A'}> } Price)