Screwy if statement

[UcfMike]

I'll do my best to explain this.

I have a calculated field which contains a simple if then else statement.

The statement says if field=value then show this number else show this number minus another number.

When I run the report, if the if condition is true it ignores the then statement and does the else statement.

If I remove the else statement, it does the then statement.

Is this to confusing?

Any ideas on what I could be doing wrong?

 

[UcfMike]

The calculated field calls two other calculated fields to make its own calculation. In one of the other two calculated fieds there is a total function. If I take that out, the report starts to produce the correct numbers. Is that a known Cognos issue?

 

[UcfMike]

I'm 99% confident I'm getting the error from the total function. Not sure why this breaks an if statement.

 

[NEAR]

You might try creating a data item with your if statement and then creating a new data item that sums or totals the first conditional data item.

 

[UcfMike]

Here is what I discovered. I adjusted the settings for the field that had the total function in it to the following. Aggregate and Aggregate roll-up are now both set to none.

This seemed to solve the problem.