If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Regarding the calculated value

Started by jahnavi, 28 Nov 2007 11:56:43 PM

Previous topic - Next topic

jahnavi

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.

Suraj

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('') .