Hi..
I have 2 data items with product codes and section codes . i have a 7 seperate conditions on product code and section codes. how to calculate .
for example if we cosider content of product codes as 'a1','a2','a3' etc and section code as 'b1','b2','b3, etc and we have some x,y,z columns which we should calculate based on product codes and section codes that is if x =(Product Code = "a1" , Section Codes except "b1" ) ,
y= (Product Code = "a1", Section Code= "b1" ),
z= (Product Code = "a1", Section Code= "b1" ,"b2","b3"),
'
'
etc
in the same query. how to do this in the report.
i tried this way but no use not working giving error
calculated data item ,x=[Product Code]='a1' and [Section Type Code]<>'b1'
and put filter on it as x='1'(for true condition)
but not working.
so please guide me on this..
No totally clear about Condition but try this and let me know
IF([Product Code]='a1' and [Section Type Code]<>'b1') then
(1)
else
(0)
now put filter on it. x=1
HalfBloodPrince I think by mistake you include the "x=" in your expression that will give an error
the right one should be the following
IF([Product Code]='a1' and [Section Type Code]<>'b1') then
(1)
else
(0)
PS: All the credits for the solution goes to HalfBloodPrince
Thanks Buddy !!!!! :D
It worked..
Thank u HalfBloodPrince..... :) :)