Boolean Formula = True/False Not Intended Value

[jlr123]

I have a formula that is giving me True or False. I need the intended Value not True or False.

Appreciate your assistance.
If GroupName ({vActivityRpt.SalespersonNo})="xyz" then {vActivityRpt.SalesManagerName}= "John Doe" OR
if GroupName ({vActivityRpt.SalespersonNo})="abc" then {vActivityRpt.SalesManagerName}= "Bob Knot"
else {vActivityRpt.SalesManagerName}= {vActivityRpt.SalesManagerName}

 

[SkipVought]

I am not a CR guru, so assuming that syntax et al are correct...

If GroupName ({vActivityRpt.SalespersonNo})="xyz" then "John Doe" OR
if GroupName ({vActivityRpt.SalespersonNo})="abc" then "Bob Knot"
else {vActivityRpt.SalesManagerName}

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!

 

[kray4660]

First off it appears you are trying to assign a value to a field and that is not possible. You can create a variable (lots resources on how to do that) and assign that value to the variable, which in turn can be displayed in the report. So I believe this is what you want. In this case (remember that formulas act like functions), no variable assignment is necessary.

If GroupName ({vActivityRpt.SalespersonNo})="xyz" then "John Doe"
else if GroupName ({vActivityRpt.SalespersonNo})="abc" then "Bob Knot"
else {vActivityRpt.SalesManagerName}

thus the results of the formula will be the if the group name = XYz then John Doe, else if the group name = abc the Bob Knot else the field {vActivityRpt.SalesManagerName}

 

[jlr123]

Thanks so much. I keep learning every day!