i am adding a dataitem and the exp is
if([Year]=?Year? and [Period] =(if(?Season? =[Spring]) then('06') else('12'))) then([Assortment Ind])else('') .At run time its showing invalid logicaloperation. I am not able to find where the error is
can any one sort out this
Thanks
Jahnavi.
Try this:
create a data item with this logic: if(?Season? =[Spring]) then('06') else('12')
and use that data item in the expression.
if([Year]=?Year? and [Period] =[Data Item]) then([Assortment Ind])else('') .