Formula explanation

[dinshak]

Can someone please explain me the formula below

Global BactId as String
dim numBactId as Number
dim lenBactId as Number
lenBactId = 0
numBactId = {RESULT.REPLICATE_COUNT}


if ({RESULT.FORMATTED_ENTRY} = "Not Applicable") then
if (numBactID = 0) then
BactId = "Not Applicable"
Formula = BactId
end if
elseif ({RESULT.FORMATTED_ENTRY} <> "Not Applicable") then
if (numBactId <= 1) then
BactId = ""
BactId = {RESULT.FORMATTED_ENTRY}
elseif (numBactId > 1) then
BactId = BactId + "/" + {RESULT.FORMATTED_ENTRY}
end if
Formula = BactId
end if

 

[IanWaterman]

This is not a crystal formula.

There is no need for end if

It is setting values for variables

Formula and BactID
Does it work in Crystal

In Crystal it would normally look like this


Global Stringvar BactId;
global numbervar numBactId;
global numbervar lenBactId;
lenBactId:= 0;
numBactId:= {RESULT.REPLICATE_COUNT};


if ({RESULT.FORMATTED_ENTRY} = "Not Applicable") then
if (numBactID = 0) then
BactId:= "Not Applicable";
Formula:= BactId

if ({RESULT.FORMATTED_ENTRY} <> "Not Applicable") then
if (numBactId <= 1) then

BactId:= {RESULT.FORMATTED_ENTRY}
else if (numBactId > 1) then
BactId:= BactId + "/" + {RESULT.FORMATTED_ENTRY};

Formula:= BactId;

Ian

 

[dgillz]

Ian,

Crystal allows the use of VB syntax. This formula should work fine.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?