Set Analysis Between values Help!

[#1]

Hi

I am trying set analysis to create dynamic expressions for profit groups. Basically I am after an expression to show where the profit amount for the selections is between the various values (£)  ie 0.-50.00, 50-100

I cannot do this in the script and I need this to be dynamic -  the table will have a cyclic group so the costs can be grouped all different levels ie store, acc man, Month. 

I have tried different variations of the below to no avail- can someone please have a look an advise where im going wrong.

0-50 (£) -- sum ({< GrossProfit= {">=00.00 and <=50.00"}>} GrossProfit )

50-100 (£) -- sum ({< GrossProfit= {">=50.00 and <=100.00"}>} GrossProfit )

Also

Sum ({$<GrossProfit={">0.00<50.00"}>}GrossProfit)

Thanks

Jo

[#2]

This works perfectly in my QV

Many Thanks

Jo

[#3]

Thanks

I am trying to use the same logic for groups based on GP (%). Can the below formula be ammended to have;

SUM(GrossProfit)/ SUM(SalesExVat)*100

instead of GPNUM in the below formula

sum ({< GPNUM= {">0<=50"}>} GPNUM)

Thanks

Jo

[kaushiknsolanki]

Hi,

     Sorry I didnt got you.

     You can create a new post and post your query with sample data their.

Regards,

Kaushik Solanki

[#5]

ok will do thanks

Jo