Adding List Column results in missing data in other column?

[jmills]

I'm adding a column to the end of an existing list report and run into the following scenario:

The added column consists of an IF statement, which basically indicates that IF 'X' then 'Y' ELSE Null

When I add this column to my list, the column to the left brings back a null Cell, however when I remove the newly added column, the Cell is no longer null.  It's like the added column is conflicting with the other, however I don't understand why?

Any input on this would be appreciated.

[Lynn]

You might try comparing the generated SQL with and without your added column. Perhaps a different join is introduced based on query items you are referencing in the expression.

Just a guess :)

[jmills]

No such luck... the SQL indicated no new joins

[MFGF]

What is the column on the left defined as? Is it a column being read direcly from the database, or is it an item calculated in the metadata model, or is it a calculation in your report? Does it refer to the item you are testing in your new expression?

MF.

[jmills]

The column to the left is another IF statement which looks for an earning code, and based on the results, calculates a result.

[MFGF]

You didn't say if the item you are trying to add also looks at Earning Code? You referred to just X in the original post. Or does your new column refer to the results of the previous one? What is X?

MF.

[jmills]

Each column searches an employees record for a specific earning code.  based on the results, each column calculates a % of earnings.  The newly added column acts in the same way, however hard codes a value based on earnings.  ie. 5000 = 2.1, 10000 = 4.2, 15000 = 8.4 etc.

Thanks for the feedback!