sum of integer dimension

[#1]

I had below mention expression in my earlier post and I was able to produce the result:

sum(aggr(sum({<[Item Type] = {"D"}>}DocDiscount) * num(Sum({<[Item Type] = {"D"}>}[Sales Price]) / Sum({<[Item Type] = {"D"}>} total<LocationCode> [Sales Price]),'#.##0.00%'),Tran_Year,Tran_Month,VoucherNo, LocationCode,Stock_Code))

But now In my another report I need to replace varchar dimenstion with below integer dimension.

discount <> 0 AND PCS > 1

So when I tryied to but I get error after <> sign

So anyone look into that and tell me what is wrong and how to form new expression with above mention condition.

Thanks

[MayilVahanan]

Hi

Where u using  discount <> 0 , in if condition or set analysis

,if set analysis means, use like this

sum({<discount -={0},Pcs = {'>1'} >}Sales)

Hope it helps

[#3]

Thanks for reply

But still I am getting RED underline (error) start from {0}

[MayilVahanan]

Hi

Thats bug in expression tab. but its shows expression ok on the expression tab. And give the result as you expected..

Hope it helps to understand it