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

Problem in static choice prompt

Started by adoremars, 08 Oct 2009 04:44:56 AM

Previous topic - Next topic

adoremars

Hi,

I have a particular field in the output which is a number eg: 45.56 and i have created a static choice prompt with selctions '=0' and '<>0'. When ever the user selects '=0' that particular field should give only 0.00 if it has and for '<>0' it should populate all others no's which is not equal to 0.

The '<>0' selection is working fine but for '=0' its populating 0's as well as the null values. I need only the 0's but.

I used this condition for the static choice.

case
when (?Reclaim Tax Amount?='=0')

then (([Reclaimable Tax on Expense Amount (reimbursement)]) = 0.00  )

when (?Reclaim Tax Amount?='<>0')
then (([Reclaimable Tax on Expense Amount (reimbursement)]) <> 0.00 )
end

Any help is appreciated.

thanks


billylodz


adoremars

The mentioned case statment is used in the filter only.

billylodz

now use filter() in Data Item

filter([xxx],[Reclaimable Tax on Expense Amount (reimbursement)] is null)

adoremars

Can you pls brief me on that?? Could'nt get it exactly..

Thanks.

billylodz

example

I have Product in Rows and Revenue in Column,
so if I do not want to see Products where Revenue is null

instead of Product I use FilteredProduct Data Item

FilteredProduct is

filter([Product],[Revenue] is not null)

adoremars

ok.. will try doing that.. Will it work for list report?


adoremars

I tried doing this but still its giving null values. But when i use IS NULL condition its populating only null values which is right.. Not working only for IS NOT NULL condition.

Any other thought?

thanks

billylodz