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
try the case statement with
case
when [field] = 0 then [rate]
when [field] = -1 then [rate]/8
else null
end
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