Adding columns

[eticket]

Hi. I have a cross tab report in which I wish to add a column containing data derived from a function. I also would like to add another column based on an arithmetic function performed on two of the other columns in the report. Are either of these scenarios possible?

Thanks

 

[synapsevampire]

Probably.

The information should be in a formula and always return a value, so fully qualify every column, as in:

If {table.field} = "Countme" then
1
else
0

If you did not have the else, it probably won't show up in your crosstab as an available formula.

If this doesn't handle your needs, try posting example data, and the specifics of your formulas (function???).

-k