Result contains "true" "false" - not values 1

[YANKRAY]

Crystal 9.0

This is the formula I created.

if {TA_LABOR_INFO.WO_RELATED} <> "Y" then {TA_LABOR_INFO.ACT_HOURS} = 0.00
ELSE {TA_LABOR_INFO.ACT_HOURS} = {TA_LABOR_INFO.ACT_HOURS}

In my report, I am getting "True" or "False" in my report.

I want the values 0.00 or the value of TA_LABOR_INFO.ACT_ACT_HOURS.

What am I doing wrong?

 

[mbarron]

As constructed you formula is checking to see if {TA_LABOR_INFO.WO_RELATED} <> "Y" - if it is then it is then telling you if {TA_LABOR_INFO.ACT_HOURS} = 0.00 and if it = "Y" then it is telling you that {TA_LABOR_INFO.ACT_HOURS} = {TA_LABOR_INFO.ACT_HOURS}
That is why you are receiving TRUE or FALSE as your result

Your formula should read:

{TA_LABOR_INFO.WO_RELATED} <> "Y" then 0.00
ELSE {TA_LABOR_INFO.ACT_HOURS}

Mike

 

[YANKRAY]

Thanks Mike, that did it.

Ray

 

[mbarron]

Mike