od and even number detection

[mart10]

I am using Crystal XI

I have the following:
if{bnkacrpt.trans_type}= "AI" and{#RTotal0}<=2 then "Interest" else
if{bnkacrpt.trans_type}= "AI" and{#RTotal0}>2 then "Withholding Tax deducted"

but on looking at data I need to actually detect if the {#RTotal0}result is odd or even How can I do this please?

 

[fisheromacse]

you could use:
remainder({#RTotal0},2) =1

 

[mart10]

It doesnt seem tro like this:

if{bnkacrpt.trans_type}="OB" or {bnkacrpt.sectype}="NA" then "" else
// The next piece test a running total to test for WHT
if{bnkacrpt.trans_type}= "AI" and({#RTotal0},2) =0 then "Interest" else
if{bnkacrpt.trans_type}= "AI" and({#RTotal0},2) =1 then "Withholding Tax" else

if{bnkacrpt.trans_type}= "GL" then "IGA Journal"
else {sectype.name}

 

[fisheromacse]

you left 'remainder' out of your formula.

also, sectioning your logic using parenthesis is not only a good practice, but can prevent crystal from misinterpreting your intentions.

if ({bnkacrpt.trans_type}="OB" or {bnkacrpt.sectype}="NA") then "" else
(
if ({bnkacrpt.trans_type}= "AI" and remainder({#RTotal0},2) =0) then "Interest" else
(
if ({bnkacrpt.trans_type}= "AI" and remainder({#RTotal0},2) =1) then "Withholding Tax" else
(
if {bnkacrpt.trans_type}= "GL" then "IGA Journal"
else {sectype.name}
)))