I'd like to do calculations in a report, based on the value of a variable. This has to yield a new field in the report with text. A calculated field cannot contain more than one statement (?), thus I cannot use the iif statement (only two values). For instance, if my variable has the value <10, the new variable should contain "low", between 10-20 "middle" and >20 "high", to be printed on the report.
This can easily be done in OPAL, but how to use this in a report? I can't attach code to a variable.

I don't know any way to do that off the top of my head. You may need to add an extra field for this notation and apply the correct label during a scan loop right before the report is displayed.

Originally posted by fepsy
I'd like to do calculations in a report, based on the value of a variable. This has to yield a new field in the report with text. A calculated field cannot contain more than one statement (?), thus I cannot use the iif statement (only two values). For instance, if my variable has the value <10, the new variable should contain "low", between 10-20 "middle" and >20 "high", to be printed on the report.
This can easily be done in OPAL, but how to use this in a report? I can't attach code to a variable.

Hi,
Did you know that you can nest iif's?
e.g. iif(my_variable<10,"low",iif(my_variable>20,"high" ,"middle"))
This will achieve the above in one statement that is in your field calculation.
The variable my_variable could be stored in a table in your private directory and referenced directly by the field calculation
e.g. iif([:priv:Temptbl.my_variable]<10,"low",iif([:priv:Temptbl.my_variable]>20,"high","middle"))
Let me know how you go.

Cheers.

Originally posted by Yuri Korin
Originally posted by fepsy
I'd like to do calculations in a report, based on the value of a variable. This has to yield a new field in the report with text. A calculated field .
.
.
.
e.g. iif([:priv:Temptbl.my_variable]<10,"low",iif([:priv:Temptbl.my_variable]>20,"high","middle"))
Let me know how you go.

Cheers.

Sorry, I'm not sure how those icons got into the body of the second example but here it is, cleared of icons.

iif([:priv:Temptbl.my_variable]<10,"low",iif([:priv:Temptbl.my_variable]>20,"high","middle"))

This is driving me nuts. Please replace the icon with ":P"

Cheers,

Yuri, edit your post and disable the smilies (checkbox at bottom). Also, thanks for the info on nesting the iifs!

Originally posted by lmckelvy
Yuri, edit your post and disable the smilies (checkbox at bottom). Also, thanks for the info on nesting the iifs!

Thanks for that. I didn't know that you could do either of those.

Cheers,

This is great, thanks! Never thought of this solution, I'll check if this works in PDOX4.5 too, it always annoyed me.
I didn't see any smileys.