calculated field in a report

[david dickie]

hi folks, i'm trying to create a field that is filled in the report depending upon the data in other fields; i.e: i've created a calculated field in the details section called CODE.if the field TY has "m" and field R_BK isblank, then CODEfield is "fl". i wrote it in the expression builder as: if(isblank("R_BK").and.TY="f","fl") the evaluation responds 'to few parameters'. am i even in the correct application(calculated fields)? there are a number of combinations for the CODE field. do i keep reentering for each combination of R_BK/TY? i don't underestand the if condition; where does the 'then' get entered? thanks, david

[Super Dave]

RE: calculated field in a report

David,

Should read as
if(isblank("R_BK").and.TY="f","fl","")
You did not finish the code
Try reading the help

Dave

[whanigsberg]

RE: calculated field in a report

"...if the field TY has "m" and field R_BK isblank then code field is FL." But what if the condition is not met. What should the code field be then. If code should be nul (blank) except when the condition is met then try

if(isblank("R_BK").and.(TY="m"),"fl","")

if code should be something else when the condition is not met then

if(isblank("R_BK").and.(TY="m"),"fl","something else here")

While we are at it, I wouldn't like to have a field named "code" as it could lead to problems.

Bill

[david dickie]

RE: calculated field in a report

thanks superdave

[david dickie]

RE: calculated field in a report

hi william, thanks. i agree and will change the field name.do i keep listing the IF expressions;i.e: if TY is: "m" ,"t","s","w", and R_BK is isblank or isnotblank for each combination of TY and R_BK the CODE field will have a different result. do i just keep making a really long expression or do i enter one, then go back and start a new expression for the next combo? thanks, david

[Ohlen Cartmell]

RE: calculated field in a report

If you have 16 or less combinations, the CASE function would work well here.

[david dickie]

RE: calculated field in a report

hi ohlen,the only thing i've found on CASE is on pg.219, where do i find more info on how to use it? much thanks, david

[whanigsberg]

RE: calculated field in a report

David:

From the help files, also xbasic doc pg. 120:

Bill


SELECT ... CASE

Syntax:

SELECT
[CASE Logical Expression1
[Statements1] ]
[CASE Logical Expression2
[Statements2] ]
...
[CASE Logical ExpressionN
[StatementsN] ]
[CASE ELSE]
[StatementsE] ]
END SELECT


Description:

A conditional control structure comprised of one or more CASE statements. The Logical Expression of each CASE statement is evaluated until a TRUE result is reached. The statements for the TRUE CASE are executed, and program flow continues after the END SELECT. The statements listed after the CASE ELSE are executed as the default action if no other CASE expression is TRUE.

Examples:

'Associate a grade with a score. Any score below 60 is an F.
'-----------------------------------------------------------
FUNCTION test_grade AS C(score AS N)
SELECT
CASE score >= 90
grade = "A"
CASE score >= 80
grade = "B"
CASE score >= 70
grade = "C"
CASE score >= 60
grade = "D"
CASE ELSE
grade = "F"
END SELECT
test_grade = grade
END FUNCTION

[david dickie]

RE: calculated field in a report

thanks bill; i'll give it a go ! david

[Ohlen Cartmell]

RE: calculated field in a report

Bill,
This is a good explanation of the Select-Case X-basic statement. I was thinking of the case function.

case(condition1,expression1,condition2,expresion2, etc,etc)

I found the explanation on page 371 of the online manual.

See you in 2 weeks.

[whanigsberg]

RE: calculated field in a report

Very true; I got turned around on this.

At this conference let's not pass each other like strangers in the night!

Bill