9 Replies Latest reply: Dec 18, 2014 3:44 AM by Jaromír Frais

# Expression limit

Dear all,

I have one dimension (costumer) and 2 expressions, where i calculate some parcial sales(goods,prints)...then i have final expression TOTAL SALES, where i sum these parcial sales (expression: "Goods"+"Prints").

Straight table returns me all TOTAL SALES of costumers. But i need to limit results - i need only costumers with total sales greather than XX usd.

My trying wasnt succesful.

Thanks a lot

Jaromir

• ###### Re: Expression limit

Write in the total expression:

If(Sum(Goods)+Sum(Prints) > xxx, Sum(Goods)+Sum(Prints), 0)

in the other two:

If(Sum(Goods)+Sum(Prints) > xxx, Sum(Goods), 0)

and

If(Sum(Goods)+Sum(Prints) > xxx, Sum(Prints), 0)

Now check the box suppress zero value and ...

let me know

• ###### Re: Expression limit

hi,

thanks, but if i take nulls instead of origin number by if condition, so staight table still shows all customers. I need to see only costumers greather than xx usd.

Do you have better solution?

Thx

j.

• ###### Re: Expression limit

neetha's solution should work..

• ###### Re: Expression limit

Hi,

Try below code in expression:

sum( {\$ <Customers={"=sum(Sales)>100000"} >} Sales)

Regards

Neetha

• ###### Re: Expression limit

Hi Neetha,

thanks, i tried your way for very easy formula and it works :-)

But i´d like to ask you for advice - for formulas im using variables and i need to know how use variable in this case.

Here check my expression,where i kept trying insert my variables - one for sales and one for costumer type limit. These variables are correct, but i dont know how to use them in your formula.

sum( {\$ <[Costumer]={"=sum(\$(eGoodSales(\$(vB2Bchannel))))>100000"} >} \$(eGoodSales(\$(vB2BChannel))))

Thanks a lot, i´l give you point ;-)

J.

• ###### Re: Expression limit

Hi,

if my guess is right try:

sum( {\$ <Customers={"=sum(\$(veGoodSales))>{\$(vB2Bchannel)}"} >} \$(veGoodSales))

or

sum( {\$ <Customers={"=sum(\$(veGoodSales))>{\$(=vB2Bchannel)}"} >} \$(veGoodSales))

• ###### Re: Expression limit

Ok,i should know, that B2B isn´t value limit...i added my two variables, first calculates sales and second defines type of costumer pricelist...and now i need to integrate them to your formula :-) thx

variable eGoods ===>      Num(Sum({\$}{<[category]={'sale'}[totalSales]),'# ##0')

variable B2B ===>            Pricelist={[PARTNER 1];[PARTNER 2];[PARTNER 3];[PARTNER 4];[PARTNER 1A];[PARTNER 1B]}

• ###### Re: Expression limit

Hi,

Try:

sum( {\$ <Customers={"=sum(\$(veGoodSales))>100000"} >} \$(veGoodSales))

Please can you elaborate on below variable,so can incorporate in above expression:

variable B2B ===>            Pricelist={[PARTNER 1];[PARTNER 2];[PARTNER 3];[PARTNER 4];[PARTNER 1A];[PARTNER 1B]}

• ###### Re: Expression limit

Hi,

it doesnt work, but it was useful advice :-) thanks