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.
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 :)
No such luck... the SQL indicated no new joins
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.
The column to the left is another IF statement which looks for an earning code, and based on the results, calculates a result.
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.
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!