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

binary

Started by pooja, 19 Nov 2008 09:20:09 AM

Previous topic - Next topic

pooja

we have data field called [New Index rate].
and we have another fiels called [BLINTERESTROUND] which is integer.it has only two binary no either -1 or 0.
here we have to display the value of [New Index rate] under these case
1) if [BLINTERESTROUND] is 0 then just a [New Index rate]
2)  if [BLINTERESTROUND] is -1 then just a 1/8th of
[New Index rate]
could you please help me out
pj

lindero

#1
try the case statement with

case
when [field] = 0 then [rate]
when [field] = -1 then [rate]/8
else null
end



Suraj

May be this does for -1.
case
when [field] = 0 then [new index rate]
when [field] = -1 then ([new index rate]/8)
else null
end