Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Thanks for reply
But still I am getting RED underline (error) start from {0}
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